| title | Create a SQL Server Database Alert | Microsoft Docs | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ms.custom | ||||||||||
| ms.date | 03/14/2017 | |||||||||
| ms.prod | sql-server-2016 | |||||||||
| ms.reviewer | ||||||||||
| ms.suite | ||||||||||
| ms.technology |
|
|||||||||
| ms.tgt_pltfrm | ||||||||||
| ms.topic | article | |||||||||
| helpviewer_keywords |
|
|||||||||
| ms.assetid | 0511136a-1b6b-4095-aa45-39e77b67aba2 | |||||||||
| caps.latest.revision | 22 | |||||||||
| author | BYHAM | |||||||||
| ms.author | rickbyh | |||||||||
| manager | jhubbard |
You can use System Monitor to create an alert that is raised when a threshold value for a System Monitor counter has been reached. In response to the alert, System 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 [!INCLUDEssManStudioFull] and [!INCLUDEssNoVersion] Agent. For more information, see Alerts.
For more information about using System Monitor to set up a [!INCLUDEssNoVersion] database alert, see Set Up a SQL Server Database Alert (Windows) .