Export (0) Print
Expand All

Creating a SQL Server Database Alert

SQL Server 2000

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

Windows 2000

For more information about creating alerts using System Monitor, see the Microsoft Windows® 2000 documentation.

To set up a SQL Server database alert using Performance Monitor

Windows NT

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

See Also

sp_add_alert

sysperfinfo

Show:
© 2015 Microsoft