posts - 230, comments - 423, trackbacks - 27

My Links



Follow billgraziano on Twitter

Article Categories


Post Categories


SQL Server

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. 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 console app that haven't made it to the GUI yet but they will soon.
  • The GUI includes a simple form to query the saved traces. You can group by SQL statement, login, host or application. You can filter by login, host or application. You can sort by CPU, Reads, Writes and Duration. You can double-click a SQL statement to see an actual statement that you can use for performance tuning.
  • I don't have much error handling in the GUI yet so let me know if you find any errors.
  • This is still very, very beta.
Download the latest version.

Print | posted on Tuesday, March 21, 2006 8:20 AM | Filed Under [ SQL Server Stuff ClearTrace ]



# re: ClearTrace 2.0.7

Hey Graz,

It may be worthwhile to actually create a small site for "ClearTrace" rather than linking me to the download. Some may understand what cleartrace is but newcomers have no clue what it is. The first thing I get when I click on a link is a download, but I dont know if its safe or not, or what it really is.

You may want to create just a simple HTML page explaining exactly what it does, maybe with some screen shots. Than in this page you could have a 'Download Now' button.

Just a thought!
3/24/2006 3:50 PM | Jon Hermiz

# re: ClearTrace 2.0.7

What is this tool and what are its advantages.
Why would someboy use it? Any qrite-up or documentation?
3/25/2006 8:00 PM | PP
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET