Kevin Remde's IT Pro Weblog
IT Pro Resources
TechNet EventsMicrosoft Security Response CenterTechNet IT Manager Community HubMicrosoft Virtual AcademyKevin’s Evaluation Download Center
IT Pro Evangelist Blogs
Blain Barton Blain Barton's Blog@BlainBar
Brian LewisMy Thoughts on IT...@BrianLewis_
Dan Stolts IT Pro Guru Blog@ITProGuru
Jennelle Crothers TechBunny@jkc137
Keith MayerIT Pros ROCK!@KeithMayer
Kevin Remde Full of I.T.@KevinRemde
Matt Hester Matthew Hester's WebLog@MatthewHester
Tommy PattersonVirtually Cloud 9@Tommy_Patterson
Yung Chou Yung Chou on Hybrid Cloud@YungChou
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.