Caveat: These tools are unsupported.
There are two tools in this kit:
- Read80Trace: a command line utility for processing trace files generated by SQL Server 2000, producing output in RML.
- OSTRESS: ODBC-based query tool that reads input from the command line, RML or delimited SQL scripts.
Released last year, these tools help you to stress-test your SQL Server processes. Overview (from MSDN):
Read80Trace is a command line utility for processing trace files generated by SQL Server 2000. As output, it generates RML files and/or a database populated with normalized data that can be useful for analyzing the performance of the system. Read80Trace requires that the destination database also run SQL Server 2000 or later.
OSTRESS is a multithreaded ODBC-based query tool. It reads its input from a command line parameter, RML file(s) produced by read80trace, or standard go-delimited .SQL scripts. In stress mode one thread is created for each connection and all threads run as fast as possible with no synchronization among the threads. This mode is quite useful for generating a specific type of stress load on the server. The replay mode provides a means to synchronize events by ensuring that they play back in the correct sequence that they originally happened, with the same relative duration between events, or both. Three key features provided by OSTRESS replay that are not in the Profiler replay tool are the ability to replay RPC events as remote procedure calls, replay attentions, and replay DTC transactions. It is also command line based so that it can be run as part of an automated process or test script.
Caveat: These tools are unsupported.