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
I received a great question in an email concerning a SQL Profiler demo I do in our live TechNet Briefings this quarter:
I attended your technical briefing in Chicago last month. Thanks for a very nice and informative session.
During the presentation for Yukon, you did a nice demo of analyzing
perfmon and trace files using Yukon profiler. I want to try that at my work. I opened up Yukon profiler but couldn't find a way to load
perfmon results for analysis. I wonder if you can help me out and tell me how to do that.
By the way, I use Beta 2 of Yukon. And my perfmon results is collected into a csv file.
Thanks in advance.
You’re welcome – in advance.
By the way – it’s okay to call it “SQL Server 2005” now, rather than Yukon.
Yeah, the tool is a little awkward in that regard. In SQL Profiler, I "Open" my saved SQL trace file, and I "Import" the performance data. In SQL Profiler you'll find that under the File menu -> Import Performance Data.
For my demo I had the performance data saved as a binary log file (.blg file), but .csv is also an option that can be imported into the profiler.