LinkedIn | FaceBook | Twitter
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.
simple run the below command on cmd.
logfile.blg is file name of perfmon file.
relog logfile.blg -f CSV -o newfile.csv