I installed SQL Server 2000 w/SP4 on a x64 Windows 2003 OS. I found that I
did not have access to the SQL performance counters and it is the same on
other servers with the same combination. Has anyone run into this issue?
What's the solution to it? thanks.Hi Jason,
Thank you for your post.
I understand that you can not view the Performance Counters of SQL Server
on a 64bit OS. If I misunderstood your concern, please feel free to let me
know.
A 64-bit perfmon client app can view OS counters plus counters for any
application that has installed a 64-bit perfmon DLL (a 64-bit app can't
load a 32-bit DLL). This means that a 64-bit perfmon client app can see a
local 64-bit SQL instance's counters, but not counters for a local 32-bit
instance running in WOW64.
A possible workaround to this problem could be:
Please run "mmc /32 perfmon.msc" from Start-Run. Please let me know whether
you can see the perfmon counters for 32-bit sql server or not.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
No comments:
Post a Comment