June 21, 2009 at 6:15 pm
I have a server running 2000 Enterprise on a Windows 2003 64-bit server (so SQL is running in WoW).
I know that to see the perfmon counters correctly I need to use the perfmon in C:\WINDOWS\SysWOW64\ on the server - which works fine, I can see all the SQL counters.
However, if I use perfmon from my PC (running Windows XP) and try to add counters for the server, I can only see the system counters (processor etc) and not the SQL ones. Is there a way I can view the SQL counters from my machine?
June 21, 2009 at 6:49 pm
OK I managed to sort it out:
Perform the following steps on the site server that you want to monitor performance data:
=========================================================================================
Modify the ImagePath value, in the following registry key, from
From:
"%SystemRoot%\System32\svchost.exe -k regsvc"
To this:
"%SystemRoot%\SysWow64\svchost.exe -k regsvc"
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\RemoteRegistry
Then in the Parameters sub-key, change the ServiceDll value
From:
"%SystemRoot%\System32\regsvc.dll"
To:
"%SystemRoot%\SysWow64\regsvc.dll"
Stop and restart the Remote Registry service. This will load the 32-bit version of the Remote Registry service, which looks to the 32-bit registry structure, causing the x64 system to send back the 32-bit counter information to the remote system.
May 30, 2012 at 6:22 am
Thanks. It's very good, certified!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply