We have a two node (sql1 and sql2) active/active cluster (Windows 2008 R2) each running two SQL instances. PRTG is installed on both nodes, the master node is sql1. The cluster is named sqlcluster.
Trying to monitor these four SQL 2008 R2 instances, I have added the a "WMI Microsoft SQL Server 2008" sensor and selected all four SQL instances. The sensor is added under a device which points to the sqlcluster DNS name.
Is this correct? The two sensors monitoring the instances on sql1 reads values fine (for example user connections), but the two sensors monitoring the instances on sql2 does not report any errors, but they both return 0 for all the values.
Any idea what is causing this?