Missing SQL Server 2000 Performance Counters

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.|||Since this thread is already closed, here is a link to it:
http://groups.google.co.uk/group/mi...5989f5fc6817daa
"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. "
We are having the same problem, and the posted work around does work:
"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. "
...But, that prevents us from being able to see the counters from our
own computers which makes troubleshooting emergencies much quicker than
having to log in to the server itself to perform this.
Does anyone know any way of being able to see these counters from a
remote computer?
Thanks.