March 2006 Blog Posts
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 give it a whirl :) There are no huge new features added but everything works a little better. Let me know what you think.
You can download the PowerPoint file and demo script from my webcast here. I'll post a link to the recorded presentation when they post it.
You can view the recorded webcast by registering here. The layout of their site is a little interesting. Follow any one of the links for Java, ColdFunsion or PHP and you'll end up at the list of sessions. On the second page, choose the link for Data Access and I'm listed as “SQL Server 2005 Developement Tips and Tricks”.
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. There is a view included to query them.
There is GUI available now. Both the console version and the GUI version are included in the ZIP file below. They have the same code behind them. There are a few options on the...
UPDATED: The content of this presentation has significantly changed. The presentation no longer covers the “What I Wish Developers Knew“ Material. Basically this turns out to be a 45 minute session with 15 minutes of Q&A and I couldn't shoe horn a 75 minute session into that amount of time. This has turned into a session on reading query plans in SQL Server 2005. It's going to start very basic with table scans and work its way up. We'll also cover Profiler and some indexing tips. My presentation is part of a series of sessions geared toward people new to...
Read80Trace generates an XML file as its result and a series of HTML files that can be used to view the XML file. I've updated ClearTrace so it can produce a nearly identical XML file for SQL Server 2005 traces.
It only generates the batch duration, batch CPU, batch reads and batch writes sections. I don't know if other people use other sections but those are the only ones I use.
It doesn't include the related HTML files. You'll need to pull those from the Read80Trace download. My advice is to run Read80Trace...