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

By Bill Graziano on 10 April 2006 | 0 Comments | 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. Follow the link to Summarizing SQL Server Trace Files (or Read80Trace for SQL Server 2005)...

Discuss this article: 0 Comments so far. Print this Article.

If you like this article you can sign up for our weekly newsletter. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

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

Pivot Table (0 Replies)

Varchar to Numeric help (4 Replies)

Database performance very poor after a moths use (6 Replies)

Repeat records depending field value (2 Replies)

CTE Duplicate Issue (3 Replies)

Dates from weeknumber (0 Replies)

Comparing rows/columns (5 Replies)

Daily Sum, Month To Date, MTD Avg, Prev Month Avg (3 Replies)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -