SQL Server Performance Tuning for RML

I found the tool RML could analysis the profiler file and show some  useful information for us, such as CPU, Reads, Writes, Duration etc…

 

Please follow these steps you could get some useful reports:

1.      Download and install this tool from sitehttp://support.microsoft.com/kb/944837

2.      Prepare the trace file by the SQL Server Profiler

3.      Run the following command in [RML Cmd Prompt]

Command: ReadTrace -Ic:\temp\PrecisionPerformance\sp_trace.trc -oc:\temp\PPBreakout -S(local) -dPPProd

Note:  [PPProd] is our database name, since we know the RML need to load data to database from trace file.

             [-I]: input the trace file

             [-o]: output the log file