O'Reilly logo

Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The by Ken Henderson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Stress Testing

There are a number of powerful third-party tools available for stress testing SQL Server. Many of these are quite expensive. What I'm about to show isn't as advanced as these types of tools, nor does it have the extensive feature set that many of them have. But it does have one advantage over them: It's free. STRESS.CMD, my SQL Server stressing tool, is a poor man's robo-test—you give it a T-SQL script to run and it runs the script a specified number of times against a SQL Server. STRESS.CMD has five main features:

  1. It can run a specified T-SQL script repetitively against a SQL Server.

  2. It can run one script multiple times or run many scripts once, or some combination of the two.

  3. It can route output to the console or it can log each ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required