Setting Up an SQL Server Database Alert

Using Windows NT Performance Monitor, you can create an alert that is raised in response to a threshold value for a Windows NT Performance Monitor counter being reached. In response to the alert, Windows NT Performance Monitor can launch an application, such as a custom application written to handle the alert condition. For example, you could create an alert that is raised when the number of deadlocks exceeds a specific value.

Alerts also can be defined using SQL Server Enterprise Manager and SQL Server Agent. For more information, see Defining Alerts.

To set up a SQL Server database alert

For more information about creating alerts using Windows NT Performance Monitor, see your Windows NT documentation.