I have quite a few Applications being monitored many of which are for SQL. I use WMI for services components and Performance Counters for components like Buffer Cache, Reads/Writes, etc. everything works fine on my SQL 2005 servers running Windows Server 2003 OS but NOT on servers with SQL 2005 running o Windows Server 2008. On these boxes the WMI counters are working fine but the performance counters are all unknown because they are not being seen by APM.
I used APM in the web console to see what performance counters were available on these serves and only a handful were being seen (obviously the SQL ones were missing) Weird as it may seem only performance objects from the later 1/2 of the alphabet (Generic IKE and AuthIP thru WFPv6) were in the list. I tried running perfmon.exe directly on the SW server and recieved the same results. When I run perfmon on the target server however, all the performance objects show up. Any clues?
