| | |||||||||||||||
| |||||||||||||||
| SQLUSA.com | |||||||||||||||
| |||||||||||||||
   |
|||||||||||||||
|
|||||||||||||||
| 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
|
| Order SQL 2008 GRAND SLAM Today! |
Microsoft SQL Server 2012 Training Videos at www.sqlusa.com.
SQL Server 2008 Video Training at www.sqlusa.com.
SQL Server 2005 Training Videos at www.sqlusa.com.
|
|
| JOIN US ON TWITTER |
Copyright 2005-2012, SMI Corp. All Rights Reserved.
SQL Server 2012 is a program product of Microsoft Corporation.
SQL Server 2008 is a program product of Microsoft Corporation.
SQL Server 2005 is a program product of Microsoft Corporation.
SQL Server 2000 is a program product of Microsoft Corporation.