| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Create a SQL Server database alert |
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. |
MikeRayMSFT |
mikeray |
12/04/2023 |
sql |
performance |
conceptual |
|
[!INCLUDE SQL Server]
If you are running Microsoft Windows server operating system, use the Performance Monitor to measure the performance of [!INCLUDE ssNoVersion]. 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 [!INCLUDE ssManStudioFull] and [!INCLUDE ssNoVersion] Agent. For more information, see Alerts.
For more information about using Performance Monitor to set up a [!INCLUDE ssNoVersion] database alert, see Set Up a SQL Server Database Alert (Windows) .