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
