People have uploaded nearly one millions rows of trace data to TraceTune. That’s enough data to start to look at the results in aggregate. The first thing I want to look at is logical reads. This is the easiest metric to identify and fix. When you upload a trace,…
I’m trying to make TraceTune (and eventually ClearTrace) work the way I do. My typical query tuning session goes like this: Run a trace and upload to TraceTune/ClearTrace Tune the slowest queries Goto 1 I might do this two or three times in one day and then not…
It was a long time coming and I hope worth the wait. If you have SQL Server 2008 R2 installed on the same box as ClearTrace and you download the latest ClearTrace build (36) you’ll be able to read SQL Server 2008 R2 traces. I also fixed a bug…
When I visit clients for the first time and conduct a performance review I introduce them to ClearTrace. It’s still the best way I know to identify exactly which queries are consuming the most resources. The downside is that it needs to be downloaded and create a database to…
One of the requests I get on a regular basis is to capture the performance of statement level events. The latest beta has this feature available. If you’re interested in this I’d like to get some feedback. I handle the SP:StmtCompleted and the SQL:StmtCompleted events. These…
It seems like all I post anymore is ClearTrace releases. I guess that’s not a bad thing. The next build is available. This is the full release of the multi-user functionality. In earlier versions all I cared about was performance. I did everything I could to make it as…
I originally envisioned ClearTrace as a service that could run in the background and process trace files. As I wrote more and more code the service and command-line versions weren’t kept up to date. I kept adding more and more caching to improve performance. That had the unfortunate side…
This is the first release of the command-line version. If you have any feedback, please post in the ClearTrace support forum on SQLTeam.com. This provides all the trace loading features of the GUI. You’ll still need the GUI in order to query the results though.…
Or my alternate SEO-friendly title, “Dynamically load the proper SQL Server SMO Trace library in C#”. I just posted a version of ClearTrace that will determine whether you have SQL Server 2005 or SQL Server 2008 installed and dynamically load the proper SMO library. Previously I had one version of…
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…