If you have a clustered environment, SQL Diagnostic Manager can trigger an alert whenever a cluster is running on a non-preferred node. The preferred cluster node is the "active" node in a cluster. By default, the preferred cluster node is the first node added when deploying SQL Diagnostic Manager in your clustered environment.

Access the Cluster Settings tab

You can access the Cluster Settings tab of the Monitor SQL Server Properties window by right-clicking the appropriate monitored SQL Server instance, and then selecting Properties. Click Cluster Settings when SQL Diagnostic Manager displays the Monitored SQL Server Properties window.

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >