I have a SQL Server 2000 cluster running on x64 OS. I found the threads in the forum to run perfmon locally by using the x86 version of perfmon (mmc /32 perfmon). However, I cannot run a perfmon remotely from another machine and see the SQL Server perfmon data on any of the nodes in the cluster. The remote perfmon picks up all of the other perfmon variables but no SQL.
I found another thread where somebody asked this question but it wasn't answered. Thanks in advance.
Mark
there is no x64 counter.|||Absolutely correct. There is no x64 SQL 2000 counter which is why one must run the 32-bit version of perfmon. I can run the 32-bit perfmon locally on my cluster nodes and see the 32-bit SQL performance counters but I am unable to run perfmon from a remote machine, connect to one of my cluster nodes and see the SQL counters.|||What do you mean by "remote computer"? Are you trying to do this across the Internet or VPN or what?
Perfmon depends on the "named pipes" protocol and will never work across the Internet because NetBios is blocked by most ISPs.
|||We are in the process of setting up Operations Manager to collect perf data. Until then we are stuck with a management server that has perfmon running on it centrally collecting data from various servers. I can see other performance counters, just not the ones for SQL Server.
The management server and the SQL cluster are on the same LAN/subnet without any type of firewall between them. I have a test cluster that is doing the exact same thing. 
