People have uploaded nearly one millions rows of trace data to TraceTune [http://www.tracetune.com/]. 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…
I’m trying to make TraceTune [http://www.tracetune.com/] (and eventually ClearTrace) work the way I do. My typical query tuning session goes like this: 1. Run a trace and upload to TraceTune/ClearTrace 2. Tune the slowest queries 3. Goto 1 I might do this two or three…
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 [http://www.scalesql.com/cleartrace/default.aspx] and you download the latest ClearTrace build (36) [http://www.scalesql.com/cleartrace/download.aspx] you’ll…
When I visit clients for the first time and conduct a performance review I introduce them to ClearTrace [http://www.scalesql.com/cleartrace/default.aspx]. 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…
One of the requests I get on a regular basis is to capture the performance of statement level events. The latest beta [http://www.scalesql.com/cleartrace/ClearTrace.2008.35.zip] has this feature available. If you’re interested in this I’d like to get some feedback. * I handle…
It seems like all I post anymore is ClearTrace releases. I guess that’s not a bad thing. The next build is available [http://www.cleardata.biz/cleartrace/download.aspx]. This is the full release of the multi-user functionality. In earlier versions all I cared about was performance. I did…
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 [http://www.sqlteam.com/forums/forum.asp?FORUM_ID=27] on SQLTeam.com. This provides all the trace loading features of the GUI. You’ll still need the GUI…
Or my alternate SEO-friendly title, “Dynamically load the proper SQL Server SMO Trace library in C#”. I just posted a version of ClearTrace [http://www.cleardata.biz/cleartrace/default.aspx] that will determine whether you have SQL Server 2005 or SQL Server 2008 installed and dynamically load the proper SMO…
It was a long time coming but I finally updated ClearTrace [http://www.cleardata.biz/cleartrace/default.aspx] 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…