Perfmon counter is handy tool for DBA to glance what happening in OS/Instance level. As DBA, you’d better to make sure related perfmon counters exist daily. Rebuild missing counter may request restart instance or reboot server, you may have difficulty to do so when you operating a critical system during business hour.
Today we share case 1: You can’t find the perfmon counter when you install 32bit SQL Server on 64bit OS. (We call it WOW- Windows on Windows).
Uhhhh, the best practice is to install 64bit SQL Server instead of 32bit on 64bit hardware. But if you have no choice or this is a legacy system..
1. Stop Performance Logs & Alerts services.
2. Run regedit. Find HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SysmonLog, change ImagePath from “%SystemRoot%\System32\smlogsvc.exe” to “%SystemRoot%\SysWow64\smlogsvc.exe”.
3. Start Performance Logs & Alerts services.
4. Run perfmon from %systemroot%\SysWOW64\perfmon.exe.
5. Create the log.