SQL Cluster Monitoring

byrona

I have a SQL cluster that consists of two nodes that are part of a VIP.  I have a WMI node in Orion that represents the VIP node so I can track performance data on the cluster no matter which node is active at the time.  This is mostly working correctly; however when the systems failover several of my performance counters (but not all) go into an "Unknown" status.  These performance counters aren't always necessarily WMI counters.  When this happens and I try to manually browse the performance counters I also am unable to see them.

Any ideas on what causes this and how to resolve it?

aLTeReGo

If you are unable to browse for them then I would try using Perfmon.exe from the Orion server to connect to the remote server and determine if they're available at all. If they aren't then likely you need to rebuild your Windows Performance Counters. Alternatively you can try and make these WMI monitors instead to see if they're more resilient to cluster failovers.