- Docs
- /
06 Jun 2022 9604 views 0 minutes to read Contributors
Doing a stress test on your SQL Server DATA, LOG and TEMPDB drives is a wise thing to do. This way you gain knowledge about the maximum I/O capacity.
In case you need to troubleshoot your SQL Server's I/O throughput this will help you. I mean, if you can compare the running numbers with the maximum throughput, you will know if you have reached your maximum or not.
The stress test consist of a series of tests with the sqlio.exe program. We have encapsulated the program (SQLIO.EXE) together with several .CMD files and a README.TXT into a zip file. You can download it here.
* SQLTreeo (c) 1998 till current date
* README.TXT
* RUNSQLIO.cmd
* RUNSQLIO_data.cmd
* RUNSQLIO_log.cmd
* RUNSQLIO_tempdb.cmd
* SQLIO.EXE
Each of the RUNSQLIO cmd's will perform a series of tests on a specific drive (-d[driveletter] )
RUNSQLIO_data.cmd is currently configured to run on -dI
RUNSQLIO_log.cmd is currently configured to run on -dT
RUNSQLIO_tempdb.cmd is currently configured to run on -dX
you should run RUNSQLIO.CMD (it will execute all the above scripts)
After the stresstest files have been received, you will receive the analysis back that will show you the MB and IOPS capacity:
In this article
Please choose a monitoring environment to connect to:
Enter your email address to recover your password.
Download link successfully sent. Check your email for details.
Reset password link successfully sent to . Check your email for details.
An email with a link for creating your password is sent to
Share link successfully sent to .
Your reply is send.
Download link successfully sent to . Check your email for details.
Download link successfully sent to . Check your email for details.
Download link successfully sent to . Check your email for details.
Download link successfully sent to . Check your email for details.
We received your request. We will contact you shortly