02 December 2006 17:22 tonyrogerson

Missing PERFMON counters using 64 bit Windows -> MMC /32 PERFMON.MSC

It took me a little while to google for the answer so I'm blogging it so I don't need to spend the time doing that again :)

If you have installed a 64 bit OS, for instance I have two machines, both running Windows 2003 Server x64; that means when you run the default PERFMON you are actually running the 64bit version of the application which can only load 64bit counter dlls; so - any counters for 32bit applications will be missing.

So, guess what - on one of my machines I'm running 64 bit SQL Server 2005 but on the other I'm just running the 32 bit but on a 64 bit OS so it runs on Wow - good old test environment.... So, the counters don't appear!

Resolution, you load the 32bit version of PERFMON to be able to read the 32 bit SQL Server counters, that is easily done by running this: mmc /32 perfmon.msc.

Thanks to Wei Lu for that answer on the public forums. What ever did we do without search engines?

Filed under:

Comments

# re: Missing PERFMON counters using 64 bit Windows -> MMC /32 PERFMON.MSC

09 May 2007 20:41 by bertcord

If you want to log you results using the CounterLogs functionality take the following steps

1) Stop the Performance Logs & Alerts service from services.msc

2) Open up the registry editor (regedit.exe), browse down to HKLM\System\CurrentControlSet\Services\Sysmonlog.

3) Change the ImagePath from the default value to %SystemRoot%\syswow64\smlogsvc.exe.( This would launch the 32-bit service on starting the Counter logs)

4) Open the 32-bit Perfmon from Start - Run - %SystemRoot%\syswow64\perfmon.exe, & add the SQL counter objects to a Counter log.

5) Set the various parameters of the Counter log, & start it to collect the data.