Missing SQL Server x32 performance counters on x64 Windows

I had an issue where I couldn’t see the SQL Server 2000 (x32) performance counters on Windows Server 2003 x64.  Looks like it’s an x32 on x64 issue.

To enable the x32 counters:

1) Stop the Performance Logs & Alerts service. Open up the registry editor (regedit.exe) and 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 x32 service on starting the Counter logs)

4) Open the x32 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.

To see the counters afterward, you need to use the x32 Perfmon by running this:

mmc /32 perfmon.msc