Return
-
Title
When do SQL Server Availability and Usability Alarms Fire? -
Description
Which Foglight Cartridge for SQL Server Availability/Usability alarms will fire against certain system status? -
Cause
Below are the expected alarms to trigger when the monitored system is in a particular status. The Foglight SQL Server agent OS extension state, if enable or disable will also factor in to what Availability/Usability alarms or if any alarms at all will trigger -
Resolution
OS monitoring disabled
OS monitoring enabled and the monitoring account has Local Administrator access to query Windows services
Shutdown the entire system DBSS - Usability Connection Availability DBSS – Usability Connection Availability, DBSS – Usability OS Connection Availability and Credential Alarm Stopped the MS SQL Server Instance from object manager in SQL Server Management Studio, the MS SQL Server Agent Service is an dependency so it should stop running as well DBSS – Usability Connection Availability DBSS – Instance Availability alarm triggered indicating the SQL Server instance was stopped. Stopped the MS SQL Server Agent Service in Services No Services alarm notifications for the SQL Server Service Agent will be triggered from Foglight. The OS extension is required to monitor Services DBSS – SQL Server agent status Took an individual SQL Server database offline from SQL Server management Studio DBSS – Unavailable Database DBSS – Unavailable Database