Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to simulate heavy database usage with SQL server 2005

How can I simulate very heavy database usage on Microsoft SQL Server 2005?

For test purposes I need to push the sql server to the max.

The server is on a virtual machine and I don't care about network load, just CRUD operations, mainly inserts because I want to demonstrate how the database grows very quickly.


1 Answers

There are 2 free utilities from Microsoft called SQLIOSim (was SQLIOSTress) to spank the IO system and OSTRESS to replay trace files.

like image 197
gbn Avatar answered Sep 24 '26 08:09

gbn