I have SQL 2016 installed on one of my servers, which is part of a SQL Cluster - so both servers are identical builds and both run Windows Server 2012R2 Standard.
I have added in the SQL 2016 WMI sensor to both servers Server1 - all 6 channels work fine
Server 2 - 4 of the 6 channels work fine, 2 refuse to play
The Buffer Manager just stays Grey and returns no results. The Locks Manager says: "Microsoft Windows Server 2012R2 Standard" does not support LockRequestsPersec (Field), AverageWaitTimems (Field), NumberofDeadlocksPersec (Field)
The locks Manager happily reports data from server1.
Server1 is the active node in the cluster, server2 the standby node.
Im guessing it throws the error because server2 is a standby node and server1 runs the SQL cluster role...
but how do i go about stopping the error sowing on server2, but being there ready to report status if the servers ever failover and server2 becomes the primary node running the SQL cluster role?