ManageEngine® SQLDBManager Plus
What is an Alarm?
Alarms are notifications generated based on some condition or criteria, helping to detect problems when any of the servers running in the network is experiencing it. This improves the fault management ensuring productive databse monitoring.
There are three severity levels for the Alarms and they are
Alarms are generated for the following type of attributes:
Availability of a SQL server. When the availability of the SQL server is down, the severity is represented as and when it is up, the severity is represented as .
Health of a SQL Server.
Attributes of a SQL Server. Alarms will be generated, if the threshold profile condition set for these attributes is met.
The Alarms screen provides the following.
Alarms Graph: This graphically represents the number of alarms based on its severity.
Alarm Views: This is an option to view the alarms based on a particular SQL Server (Monitor) by selecting them from the respective combo box.
Alarms list: This lists of all the alarms with details such as SQL server name, Status, Alarm Message, Date/Time, and Technician who attended on the Alarm. You have an option to display 25/50/75/100/125 Alarms per page. Alarms can be acknowledged by the Technicians (Users) by picking up alarms, likewise unpicking of alarms is also possible. Options to add, delete and edit annotations is available. By Clicking on 'Set as Clear' link, you can change the state of the selected alarms from Critical/Warning to Clear state. By clicking on the 'Alarm Message' link, you can view the Alarm Details. Also, you can view the history of the alarm by clicking on the History Report PDF.
Alarms for traps: Traps received via SNMP Trap Listener can be seen here. Also, the other unsolicitated traps can be viewed here.
Quick Links: Refer to the Alarm Details section.
The following steps will generate alarms and perform actions based on your configuration. Go through the following sections to know about the configurations.
Creating Threshold Profile
Associating Threshold and Action with Attributes
Configuring Consecutive Polls
SQL Server Audit Reports with Real Time Alerts