| title | Create a SQL Server database alert | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| description | You can use Windows System Monitor to create a SQL Server database alert that is raised when a threshold value for a System Monitor counter has been reached. | |||||||||
| ms.custom | ||||||||||
| ms.date | 07/13/2021 | |||||||||
| ms.prod | sql | |||||||||
| ms.prod_service | database-engine | |||||||||
| ms.reviewer | ||||||||||
| ms.technology | performance | |||||||||
| ms.topic | conceptual | |||||||||
| helpviewer_keywords |
|
|||||||||
| author | WilliamDAssafMSFT | |||||||||
| ms.author | wiassaf |
[!INCLUDE SQL Server]
If you are running Microsoft Windows server operating system, use the System Monitor graphical tool to measure the performance of [!INCLUDEssNoVersion]. 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) .