Alert is an object that is defined to react on certain event. The event can be, for example, some error that is raised on SQL Server. When such a situation occurs, the alert itself just remembers the occurrence in the form of a counter (how many times the error was noticed) and the last time of the occurrence. The benefit of using alerts lies in the possibility to set some response action. A response action could be an operator notification, job execution, or both.
We have three alert types:
- SQL Server event alert: This type of alert looks for SQL Server errors logged to the error log
- SQL Server performance condition alert: These alerts can check the value change of a certain performance condition counter provided by SQL Server (not ...
