Versions Compared

Key

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

...

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

Cluster Failover Alert

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

  • Clears after 12 hours if no additional alerts are generated on the cluster.
  • Generates an additional alert if another cluster failover occurs.
  • Clears instantly when manually cleared.

Cluster Active Node Alert

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 detects that a clustered SQL Server instance is running on a node other than the configured preferred node.

Best practices for using the Cluster Alerts

Choose the alert that best reflects your environment and setup notifications for it. Disable the other alert if it is not necessary.

...