SQL Server Database Offline


When the status of a SQL Server database goes into a state other than ONLINE, this alert will return a value of 1 (true), otherwise it will return 0 (false). When configuring thresholds for this alert, use the value of 1 as the Critical level and DPA will let you know when a database is not ONLINE.



To create this alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return and configure as needed.