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:
It can run a specified T-SQL script repetitively against a SQL Server.
It can run one script multiple times or run many scripts once, or some combination of the two.
It can route output to the console or it can log each ...