SQLStress - A SQL Server Stress Test Tool


Walkthrough

After installing SQLStress, start it from the program menu. To install SQLStress the .NET Framework 2.0 must be installed first. SQLStress runs on Itanium, on x86 and on x64 and can stress SQL Server 2005 and SQL Server 2000 except for the "roundtrip" transaction that will not work on SQL Server 2000.

On the <Connect> tab, specify a server hosting an existing database and click on <Add Database>. A connection attempt to this database will be performed. If successful, the database will be added to the list of databases used to create workloads and shown on the <Databases> tab.

On the <Databases> tab, assuming this is a database you never used with SQLStess before, right click the database and select <Database → Prepare>. All necessary data to run SQLStress is created on that database (To get rid of these definitions and the test data, click <Database → Cleanup> afterwards).

Go to the workload tab, click on <Create>, a workload is created that corresponds to the last used settings. Click on <Sign In> and the users are connected to the database or click <Run> and the workload is started immediately. Check the journal tab for errors and other messages. You can use the <Pause> button to disconnect from the database and the <Run> button to restart the workload repeatedly. The <Done> button will rundown the workload and dispose it.

The workload runs until the specified number of transactions have been performed. If the number of transaction to be performed are specified as zero, the workload runs until the <Done> or <Pause> button is clicked.

SQLStress is resilient to Cluster failover or other outages, it will just resume work if the database gets available again. Operations can be monitored with the "Windows Performance Monitor". A SQLStress performance object has been added at installation time except for "Click Once" installations, see "Performance" tab.