I received a great question in an email concerning a SQL Profiler demo I do in our live TechNet Briefings this quarter:

Kevin,

 

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.