How to set up a SQL Server database alert (Windows 2000)

How to set up a SQL Server database alert (Windows)

To set up a SQL Server database alert

1. On the Tree tab of the Performance window, expand Performance Logs and Alerts.
   
   
2. Right-click Alerts, and then click New Alert Settings.
   
   
3. In the New Alert Settings dialog box, type a name for the new alert, and then click OK.
   
   
4. Click Add to add a counter to the alert.

   All alerts must have at least one counter.

5. In the Performance Object list, select a Microsoft® SQL Server™ object, and then in the Select counters from list box, select a counter.
   
   
6. To add the counter to the alert, click Add. You can continue to add counters, or you can click Close to return to the Alert dialog box.
   
   
7. In the Alert dialog box, click either Over or Under from the Alert when value is list, and then enter a threshold value.

   The alert will be generated when the value for the counter is more than or less than the threshold value (depending on whether you clicked Over or Under).

8. In the Sample data every boxes, set the sampling frequency.
   
   
9. On the Action tab, set actions to occur every time the alert is triggered.
   
   
10. On the Schedule tab, set the start and stop schedule for the alert scan.

See Also

Creating a SQL Server Database Alert