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
During the presentation for
perfmon and trace files using
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.