SQL Server 2005 Tidbit 039
SQL Server 2005 Tidbit 039
I have talked about and demonstrated the new SQL Server Upgrade Advisor in my live events recently. When showing that you can include a profiler trace file for the sake of the analysis, I was asked,
“But what events should we trace? What trace would be the most useful for the advisor?”
And the person asking also pointed out (and I verified later) that there really isn’t any good help on this currently available.
So I asked some folks I know.
The answer: Use the TSQL_Replay template to create that trace file.
“TSQL_Replay is the best template to use. The goal would be to trace as many different queries as possible, rather than tracing the same query multiple times.
”
—
Got an IT question? Give me a comment, or contact me.