Create a SQL Server database alert

Applies to: SQL Server - Windows only

If you are running Microsoft Windows server operating system, use the Performance Monitor to measure the performance of SQL Server. You can use Performance Monitor to create an alert that is raised when a threshold value for a Performance Monitor counter has been reached. In response to the alert, Performance Monitor launches 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 by using SQL Server Management Studio and SQL Server Agent. For more information, see Alerts.

For more information about using Performance Monitor to set up a SQL Server database alert, see Set Up a SQL Server Database Alert (Windows) .