The Cluster Active Node alert indicates that the active node of the cluster is non-preferred. The active cluster node changes when a failover event occurs. If the original preferred node is offline for an extended period of time, you can change the preferred node setting by right-clicking the instance in the Servers tree and selecting Properties > Cluster Settings. By default, the preferred node is first node encountered when monitoring began.



SQL Diagnostic Manager for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.
IDERAProductsPurchase | Support | Community | Resources | About Us | Legal