SQL Server - Simple Readtrace demo

Project Description
So you think SQL Nexus is a good tool? Yes me to. But setting up SQLDiag can be a bit tricky. In many cases I'm fine just running Readtrace to parse,normalise and generate my topN queries from a minimum trace definition. I wrote a batch file for a Demo session to make a really simple example of how to do just that.
Should work on any SQL edition between 2000 - 2008 R2.

This is also an easy way for me to fetch trace data from a remote customer where they don't have a DBA available, and I don't have access to the environment. Use Readtrace to do the trace analyse off site.

Readtrace.exe is a prerequisite to do the analysis of collected trace,
get it from Microsoft as part of RML Utilities: http://support.microsoft.com/kb/944837
Readtrace.exe will parse the trace file(s) and help you normalise and summaries metrics from trace file(s).

note: Readtrace can not read SQL Server 2012 trace files, so for tracing and analysing SQL Server 2012 consider XEProfiler and Distributed Replay:
http://msdn.microsoft.com/en-us/library/ff878183(v=sql.110).aspxhttp://blogs.msdn.com/b/psssql/archive/2011/01/12/sql-denali-dreplay-xeprofiler-or-rml-utilities.aspx

... however. It's possible to change the version flag in the trace file header from 11 to 10!
http://spaghettidba.com/2012/11/08/more-on-converting-trace-files/
nice :-)