SQLTeam.com | Weblogs | Forums

Importing SQL Server 2005 Trace Files

I previously wrote a utility called ClearTrace that monitored trace files and automatically loaded them into SQL Server. I've started a similar program for SQL Server 2005. Right now this utility doesn't automatically import trace files on rollover. That functionality should come soon though. I wasn't planning on releasing the tool but it looks like we're not going to see Read90Trace anytime soon. This utility does normalize SQL statements in a way similar to Read80Trace. For example it takes this SQL:

This is a companion discussion topic for the original entry at http://billg.sqlteam.com/2006/02/26/9126/