How to set up a SQL Server database alert (Performance Monitor)

To set up a SQL Server database alert

1. On the View menu, click Alert.
2. On the Edit menu, click Add to Alert....
3. In the Object list, click a SQL Server object, and then click a counter, on which the alert will be based, from the Counter box.
4. Under Alert If, click Over or Under, and then enter a threshold value. The alert will be generated when the value for the counter is over or under the threshold value (depending on whether Over or Under was selected).
5. Click First Time or Every Time to determine how often the alert is generated. The default is Every Time.

See Also

Setting Up a SQL Server Database Alert