A SQL Server instance went offline in a Windows cluster environment but an alarm was not generated.
In what scenarios would an alarm fire for a database that goes offline on a clustered environment?
Scenario A -> SQL Agent Service turned off at Node A and Node B; no failover
SQL Agent Service Alarm occurs for the cluster agent because the instance isn't available; no metrics collected.
No cluster failover alarm.
Scenario B -> SQL Agent Service turned off at Node A only; no failover
SQL Agent Service Alarm occurs for the cluster agent because the instance is unavailable; Node B is still active but Foglight doesn't communicate with it; no metrics collected.
No cluster failover alarm.
Scenario C -> Cluster Failover of Node A to Node B; SQL Agent untouched
Cluster Failover alarm fires for agent; metrics collected now from Node B.
