Creating a SQL Server Database Alert
Using System Monitor (Performance Monitor in Microsoft® Windows NT® 4.0), you can create an alert to be raised when a threshold value for a System Monitor counter has been reached. In response to the alert, System 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.
Note Performance condition alerts are only available for the first 99 databases. Any databases created after the first 99 databases will not be included in the sysperfinfo system table, and using the sp_add_alert procedure will return an error.
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 using System Monitor