missing sql performance counters on windows 2003 x64

21 Jul

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

Leave a comment

Posted by on July 21, 2010 in SQL Server


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: