ReadTrace for SQL Server 2005

Microsoft just released an updated Read80Trace that works on SQL Server 2005.  The name is simplified to just ReadTrace.  ReadTrace is a command-line utility that analyzes a SQL Server trace file and summarizes performance.  The new version has a more graphical interface.  The original was one of the most helpful…

Read90Trace coming soon!

Bob Ward announced in his PASS pre-conference session that Microsoft will be releasing a SQL Server 2005 version of Read80Trace in roughly 30 days.  It's currently going through a security review.  They're planning to call it ReadTrace instead of Read90Trace though.  I don't know what this will do to my…

ClearTrace 2.0.27 Released

I posted another version of ClearTrace just a minute ago.  This should process 64-bit trace files on either x86 or x64 machines.  If you have trouble please post in the ClearTrace Support Forum.  Please visit the ClearTrace download page for the software.  Don't forget to enter the beta code "jayhawk"…

Saving Multiple Traces in ClearTrace

Back when I actually had time to work on ClearTrace I had visions of selling the software.  I don't think that's going to happen anytime soon.  I don't have time and there's a bug in SMO that causes problems with traces generated on 64-bit servers.  In the meantime, there is…

Yet Another ClearTrace Update

These titles seem to be getting repetitive. I updated ClearTrace again. I'm also back to using a ClickOnce installer. Unfortunately if you switch from an unsigned to a signed ClickOnce installation the existing people can't upgrade. How annoying! That was half the reason I switched to an MSI installer. Creating…

ClearTrace Updated

I've been updating ClearTrace for a while now and there's a new version available.  I stopped using ClickOnce and switched to an installer.  If you're interested in analyzing trace files and summarizing the performance of your SQL take a second and download it.  It does require SQL Server 2005 to…

ClearTrace Updated

Since I last posted here I've updated ClearTrace.  You can download it here.  There's also a ClickOnce installation if you just want to use the GUI version.  ClearTrace now supports moving the trace files to an archive directory after they're processed.  It also stores a summarized version of the trace…

ClearTrace 2.0.9

I released ClearTrace 2.0.9.  You can find the information here.  I moved the download to my corporate site so I can keep a static page up for information.  I'm pretty happy with this version.  It seems to be very useable.  It also reports errors back to me so…

ClearTrace 2.0.7

I've made some pretty significant changes to this tool. It now writes to multiple tables instead of a single table. This greatly reduces the space required and the import time. It creates the objects it needs in the database specified. All the objects have a CT prefix in the name.…