What is alarm manager (database)?

In SQL Server, an alert is defined as alarm manager. It will alarm automatically when some particular events occur. When the alarm is triggered, the notification by e-mail or paging operators, that letting system operator to know what is event, such as lack of database space or transaction log is full. Errors, events generated by SQL Server will be recorded to the Windows NT application logs, compared the reading logs of SQL Server with the event with definition alarm, if it's match, the alarm will be triggered. In SQL Server, there are two kinds of alarms created by alarm manager: Event Alarm and performance condition alert.

Creating an event Alarm:
1. Run "SQL Server Enterprise Manager", and log onto specified server, then click "management" -> "+" in the left of SQL Server Agent;
2. Right-click "Alerts", choose "New Alerts", open the dialog box of New Alert Properties. Choose "General";
3. Choose "Error number" then click button in the right, open the dialog box of "Manage SQL Server Messages", choose tab of search;
4. Choose Message tabs，click "New", open the dialog box of "New SQL Server Message";
5. Click "OK", back to the dialog box of New Alert Properties, choose tab of Response.

Creating a performance condition alarm is almost the same as event alarm, but just a little different:　
When open the dialog box of "New SQL Server Message", choose "General", choose "Server performance condition alert" in the drop-down of Type.

Readers also visit these:

Related Questions: