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