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 identifies and resolves SQL Server performance problems before they happen. Learn more > >