Microsoft SQL Server 2008
Performance Tuning
Best Practices

How to read a SQL Profiler trace file?

 

Execute the following script in Query Editor to list the SQL Server Profiler trace file.

use AdventureWorks2008;

 

SELECT *

FROM :: fn_trace_gettable('F:\data\PerfLogs\ProfilerTrace\SlowQuery.trc', 1)

ORDER BY StartTime

 

 

 

 

 

The Best SQL Server 2008 Training in the World
 
 
SQLUSA.com Home Page