RSS

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

Advertisements
 
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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

w

Connecting to %s

 
%d bloggers like this: