Kevin Remde's IT Pro Weblog
IT Pro Resources
IT Pro Evangelist Blogs
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.