PERFMON issue for remote machine

  • Hi,

    I have 2 machines X and Y. I am using X machine to run perfmon which will remote connect to Y machine and collect the counters for Y machine. I am surprised to see that I am not able to see the counters for SQL Server 2008 R2 64 bit when I remote connect the perfmon on X machine to Y machine.

    However, when I directly log in to Y machine and open perfmon, I can see the counters for SQL Server 2008 R2 64 bit !!

    What is not allowing me to see those counters while connecting remotely?

    I have same adminstrator rights on both machine for my login and use same login details to log into both machines. Both machiens X and Y are in same network and same domain.

    Any help will be appreciated.

  • Do you have the SQL management tools for 2008 R2 installed or a different version?

    Sometimes perfmon does not display those counters without the Mgmt tools for SQL Server installed.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • I have the required management tools installed.

  • What is the OS of Machine x and do you get any error messages?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • OS of both machines are same(Win Server 2003 SP2)

  • Try the steps outlined in this article and see if it helps.

    http://blogs.msdn.com/b/psssql/archive/2009/03/03/troubleshooting-sql-server-2005-2008-performance-counter-collection-problems.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply