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.

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

11 June 2008 10:58 by blakmk

cheers tony,

It stopped me chasing my tail on this one!

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

26 July 2010 22:13 by cehottle

On a Windows Server 2008 64 bit/SQL Server 2008 32 bit installation, I followed these directions and was able to see the SQL Server counters in the new Performance tool.  What I can't figure out is how to access those counters from a remote monitoring server hwre we gather Perfmon data.  If anyone knows how to resolve that, it would be a big help.  Thanks.

# ODP.NET – “Pooling” and “Connection request timed out” « Joao @ iLab8

Pingback from  ODP.NET – “Pooling” and “Connection request timed out” « Joao @ iLab8