02 December 2006 17:22
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: SQL Server