Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I've got a couple of servers running SQL Server 2005 Enterprise and I'd like to monitor them remotely using Perfmon (Windows' Performance Monitor).

On my machine, I have an instance of SQL Server 2008 R2 Developer, and I noticed that there are a bunch of SQL Server specific performance counters, like MSSQL:Buffer Manager, MSSQL:Databases, MSSQL:Memory Manager, MSSQL:Transactions, MSSQL:Wait Statistics, etc.

If I connect to both servers using Remote Desktop and open Perfmon at the server, I can see all those counters. When I connect to the server from my machine directly via Perfmon (not using remote desktop) and select counters from the remote computer (\SERVERNAME), I can see all kinds of performance counters (like .NET CLR Jit, Networking, Processes, etc.), but not those from SQL Server.

Please note that I'm using a domain login that has admin permissions on the server.

Do I have to enable something on the server that allows me to monitor the SQL Server's specific performance counters? Am I missing something?

share|improve this question
add comment

1 Answer

up vote 5 down vote accepted

What are the versions of your SQL server and your remote monitor machine? If your remote monitor machine is 32 bit and your sql server is 64 bit, perhaps you cannot consume the SQL performance counters remotely. This MSDN link explained the reason.

share|improve this answer
    
Thanks! Indeed, my local machine is running a x86 client version of Windows and the server is running x64. If I had one more point I'd upvote you, but unfortunately I can't :) –  ivanmp Feb 14 '12 at 17:24
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.