Summarizing SQL Server Trace Files (or Read80Trace for SQL Server 2005)

By Bill Graziano on 10 April 2006 | Tags: SMO , Profiler & Trace


One of my favorite tools for SQL Server 2000 is Read80Trace. It reads a trace file and summarizes the SQL to identify the statements and stored procedures that use the most resources. It appears Microsoft won't be releasing a version that will read SQL Server 2005 trace files.

That gave me a good reason to write my own version that will read SQL Server 2000 and 2005 trace files. It has a commnand-line version and a GUI version. The GUI version will import the trace files and let you query them based on application, host and login and sort based on CPU, Reads, Writes, Duration and number of executions. The data is stored in a database so you can query it yourself or store it for future use.

Link: ClearTrace

The GUI application can send feedback directly to me. I'd like to hear what you think and any suggestions on how to improve it. It does require SQL Server 2005 on the computer where it runs since it uses SMO to query the trace file.

Link: Summarizing SQL Server Trace Files (or Read80Trace for SQL Server 2005)


Related Articles

Testing with Profiler Custom Events and Database Snapshots (22 June 2009)

Introduction to SQL Server 2008 Extended Events (19 May 2009)

Integrating Profiler and PerfMon Log Files (6 February 2008)

Examining SQL Server Trace Files (15 May 2006)

Scripting Database Objects using SMO (Updated) (29 November 2005)

Reading a Trace File using C# in SQL Server 2005 (25 October 2004)

PASS 2004 Presentation: Profiler and Trace in SQL Server 2005 (3 October 2004)

Automatically Process SQL Server Trace Files (15 September 2004)

Other Recent Forum Posts

T-sql - we created Message from app1 and trying to disable from app2 (60m)

SQL select Top 10 records for unique combination of two columns (14h)

SSRS Report Sorting with Grouping Issue (1d)

ORA-01476: divisor is equal to zero (1d)

Create new columns based on min and max values of a record with multiple rows (1d)

Memory Required for Reporting Services 2022 (1d)

Backup sql server large db on cloud (2d)

Selecting x columns but only displaying y columns (2d)

- Advertisement -