Download details: RML.EXESupport Tools Available For Stress Testing & Performance Analysis

29 September, 2004 (05:38) | SQL Server

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.

Download here

Write a comment