SQL Server Performance

Perfmon - Zeros on SQL Counters

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by asc11, Aug 15, 2008.

  1. asc11 New Member

    Hi all,
    I have recently set up performance monitoring for all the SQL Server instances in our environment. One of the servers, however, is reporting all zeros for SQL Server related counters. What I have done so far:
    • Opened perfmon on my local machine - returns all zeros
    • Checked sys.dm_os_performance_counters - plenty of values there
    • Opened perfmon on the remote server - also plenty of values
    • Opened perfmon on the remote server with the /wmi switch - returns all zeros (hmmm... sounds like a WMI issue)
    • Checked all permissions on OS groups and WMI namespaces - looks good
    • Connected to SysmonLog WMI class on "working" server - returns two instances, one is specifically for SQL Server
    • Connected to SysmonLog WMI class on "not working" server - returns no instances
    This tells that SQL Server somehow did not register an instance under the SysmonLog WMI class. So how do I do that without having to reinstall SQL Server (I'd really rather not have to reinstall)? Or am I barking up the wrong tree? Google has gotten me to this point, but now I'm stuck. Any help would be appriciated.
    Thanks in advance.
  2. satya Moderator

    What is the service pack level on SQL & Windows?
  3. asc11 New Member

    Windows 2003 Enterprise x64 R2 w/ SP2
    SQL Server 2005 Enterprise x64 w/ SP2 + CU1

Share This Page