How to simulate the use of a large database with SQL Server 2005

Question

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

For test purposes, I need to push the sql server to the maximum.

The server is located in a virtual machine, and I do not care about network loading, just CRUD operations, mostly inserts, because I want to demonstrate how the database grows very quickly.

Answer 1

There are 2 free utilities from Microsoft called SQLIOSim (was SQLIOSTress) to spank the I / O system and OSTRESS to play back trace files.

Answer 2

, , , , SQL Profiler. , ; , .

; . .

, - gui?

Answer 3

, , , 1000000 , ( - , ..), - .

As for the testing framework, you can quickly start with something like JUnit if you are doing java (or the equivalent for other languages ​​- PhpUnit, Nunit, PyUnit, etc.).

Take a look at Testing> and the List of Unit Tests framework for detailed lists.