Do you need to use the excellent RMLUtilities (in particular ReadTrace) against SQL Server 2008 trace files? Well, ReadTrace does not support 2008 yet but if you need to convert your files , please try this free utility:
This is a command line tool, simply jump to the command line and use as follows:
trace.convert.exe -iC:TraceFiles (or any other folder).
Trace Convert will then convert all trace (.trc) files in this folder so that they can be used with ReadTrace. You can optionally include -r so that is converts trace files in all sub folders (recursively).
If you have a new SQL 2008 database and have used the new datatypes, this tool is not guaranteed to work as expected and you should wait until the new readtrace has been released that is compatible with SQL 2008. However, this is very handy for upgraded SQL 2005/2000 databases where you want to analyse trace output of re-playable traces.
Give it a try and see if it helps you..
3 comments
Comments feed for this article
July 11, 2008 at 12:04 pm
Coolcoder
This doesn’t seem to work in RC0, so possibly not RC1/RTM. I am looking into this.
October 22, 2008 at 9:31 pm
RUSure
Doesn’t seem to work at all. I tried 3 different SQL 2005 environments. Nope.
November 12, 2008 at 10:36 am
Coolcoder
This worked on pre RC0 installations, it appears they changed the format slightly after this. If anyone knows a way around this then…