posts - 219, comments - 411, trackbacks - 27

My Links

Advertisement

News

Follow billgraziano on Twitter

Article Categories

Archives

Post Categories

Consulting

SQL Server

ClearTrace updated to support SQL Server 2008 trace files

It was a long time coming but I finally updated ClearTrace to read SQL Server 2008 trace files.  This requires SQL Server 2008 to be installed on the computer where ClearTrace is running.  ClearTrace will process traces created in SQL Server 2000, SQL Server 2005 and SQL Server 2008. 

ClearTrace is the tool I wrote to make performance tuning easier.  Many of my client engagements are to make SQL Server faster and ClearTrace is the tool I use to do that.  ClearTrace will read a series of trace files and aggregate the results so you can tune the queries that use the most resources.  It’s available free of charge at the link above.

image

I also cleaned up a bunch of old code that would report errors and performance data back to a web service if you checked the proper boxes.  Since I hadn’t looked at that data in over a year I decided not to capture it anymore.  Any horrible errors that occur will be saved in a text file near the executable.  You can post them to the ClearTrace Support Forum and I’ll try to figure out what’s going on.

Please let me know if you have any problems or how well the software works for you.

Print | posted on Sunday, March 29, 2009 12:07 PM | Filed Under [ SQL Server Stuff Utilities ClearTrace ]

Feedback

Gravatar

# re: ClearTrace updated to support SQL Server 2008 trace files

Very interesting solution. This should be much much easier to find the performance consumers than using ::fn_trace internals.
Thanks, Vadym.
3/30/2009 3:03 AM | Remote DBA
Gravatar

# re: ClearTrace updated to support SQL Server 2008 trace files

Awesome! I've been waiting for cleartrace 2008 and I was also looking forward to the "Trace group" feature you forgot to mention you added!

Great!
3/30/2009 12:01 PM | Saggi Neumann
Gravatar

# re: ClearTrace updated to support SQL Server 2008 trace files

Bill, does ClearTrace offer command-line support so that we can schedule it to be run?
3/30/2009 2:02 PM | Tara
Gravatar

# re: ClearTrace updated to support SQL Server 2008 trace files

It doesn't support a command-line environment right now. That's been something that I've been considering for a while now. I might see if I can make some time to work on it.
3/30/2009 2:26 PM | Bill Graziano
Gravatar

# re: ClearTrace updated to support SQL Server 2008 trace files

Performance Data Collector is good alternative for such parsers in SQL Server 2008.
3/31/2009 3:50 AM | vadym
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET