Opening a Windows Perfmon File in Profiler – Part Two

In a previous blog entry, I mentioned you could import a Windows Perfmon log into SQL Server Profiler. I received a note that someone was having a problem doing this, and when we looked over his situation, it turned out that he was using a Windows Perfmon binary log, a SQL Server 2008 trace file – and he was running the whole analysis in XP. I’m not sure if that’s the issue, since I’ve converted my last XP machine.

There is a fix, however. When you save the data in Perfmon, or at least before you bring the file over to XP for analysis, save it as a CSV file. The Perfmon tool should be able to open it if it’s a binary issue, and then you can save it as a CSV from there.

Comments (1)

  1. Sanjay Kumar says:

    simple run the below command on cmd.

    logfile.blg is file name of perfmon file.

    relog logfile.blg -f CSV -o newfile.csv