Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

SQL diagnostic manager Diagnostic Manager allows you to monitor your clustered SQL Server environment including alerts when a failover occurs and when the preferred active cluster node changes.

An important way to track clustering events using SQLdm SQL Diagnostic Manager is through the usage of cluster alerts.

...

By default, this alert is enabled and set to Critical. When a failover occurs, SQLdm SQL Diagnostic Manager generates an alert and then performs one of the following actions:

...

The preferred node. You can change this setting on the Cluster Settings tab of the Monitored SQL Server Properties dialog box. The Cluster Active Node is triggered when SQLdm SQL Diagnostic Manager detects that a clustered SQL Server instance is running on a node other than the configured preferred node.

...