ClearTrace for Extended Events

I found the time to update ClearTrace to support Extended Events.  You can download ClearTrace for Extended Events from my corporate site.  A few notes about this buildIt's a very early release.  Everything seems to work for me and it passes all the tests.  Please report any issues in the…

ClearTrace Build 51 Available

I’m pleased to announce that ClearTrace Build 51 is now available for download.  If you’re using a previous build (especially build 50) I encourage you to download this version. This build should load the latest version of the SMO libraries installed on your machine.  If you’re using…

ClearTrace Build 47 Available

You can download the latest version of ClearTrace from my consulting site: scaleSQL Consulting.  I’ve decided to stop using the year as part of the version.  I did that to match SQL Server branding but it doesn’t work for ClearTrace.  The current build supports SQL Server 2008, SQL…

ClearTrace for SQL Server 2012

I’ve updated the beta for ClearTrace that support SQL Server 2012.  This requires SQL Server 2012 to be installed on the computer where ClearTrace is running.  It will read traces from SQL Server 2008 R2, SQL Server 2008 and SQL Server 2005. It includes some minor improvements in performance…

ClearTrace Performance on 170GB of Trace Files

I’ve always worked to make ClearTrace perform well.  That’s probably because I spend so much time watching it work.  I’m often going through two or three gigabytes of trace files but I rarely get the chance to run it on a really large set of files. One…

TraceTune display Duration in milliseconds. Finally.

SQL Server 2008 started reporting the statement duration in microseconds in scripted traces.  That’s one millionth of a second.  Previously they were reported in milliseconds.  Profiler automatically corrects for this and always displays in milliseconds regardless of the version of SQL Server that generated the trace.  However SMO reported…

TraceTune shows Reads graphically

TraceTune now shows a graphical view of logical reads for each SQL statement in a trace file.  The width of the colored bar in the screen capture below is the percentage of logical reads for that statement.  The absolute number of reads is shown to the right. Any statement that…

TraceTune supports uploading Zip files

I’ve been using the online version of ClearTrace more and more lately.  When I get to a new client it’s just much easier to upload a trace file rather than install ClearTrace. That means I’ve finally been adding more features to it.  The two latest features are…

ClearTrace Shows Execution History

The latest release of ClearTrace (Build 38) now shows the execution history of a particular statement. You’ll need to save the trace files to a trace group instead of just using the default.  That’s as easy as typing something into the trace group name when you upload the…