为什么要启用警报 (Why should you enable alerts)
While the article “How to create and configure SQL Server Agent Alerts” created by Minette Steynberg a SQLShack author discusses the features around Alerting through SQL Agent and some conditions for testing. It does not go through some of the common alerts that you should have enabled on your SQL Server.
虽然文章“ 如何创建和配置SQL小号 Ë rver代理警报 ”通过创建米内特Steynberg一个SQLShack笔者讨论通过SQL Agent和周围的警报功能测试一定的条件。 它不会通过应在SQL Server上启用的一些常见警报。
To give a brief overview, Agent Alerts can provide monitoring of important events or conditions using the alerts feature three different ways:
为了简要概述,代理警报可以使用警报功能的三种不同方式来监视重要事件或状况:
- SQL Server event alerts – alerts when a specific SQL Server even occurs
- SQL Server事件警报 –甚至在发生特定SQL Server时发出警报
- SQL server performance counters – alerts when a performance counter reaches the specified threshold SQL Server性能计数器 –性能计数器达到指定阈值时发出警报
- WMI events – alerts when WMI reaches a specific threshold WMI事件 – WMI达到特定阈值时发出警报
This is important to make sure you are properly keeping an eye on your SQL Server. In my opinion, monitoring WMI events or performance counters with SQL Server is an expensive substitute for a monitoring solution. Thus, we will be focusing on the SQL Server event alerts.
这对于确保正确监视SQL Server非常重要。 我认为,使用SQL Server监视WMI事件或性能计数器是监视解决方案的昂贵替代。 因此,我们将专注于SQL Server事件警报。
重要严重性警报 (Important Severity Alerts)
When implementing this, it is a common practice for DBAs to enable alerts for Severity 17 or higher on their SQL Servers. This is because these are not correctable by end users. Again, I believe everyone should have a monitoring solution in place even if it is just monitoring resources on the machine, for this reason, I only enable them for 18 and above. If you don’t have a monitoring solution though, please enable alerts for 17 also. Error 17 indicates that a statement caused SQL Server to run out of resources.
实施此操作时,DBA通常在其SQL Server上启用严重性为17或更高级别的警报。 这是因为最终用户无法纠正这些问题。 再一次,我相信每个人都应该有一个监控解决方案,即使它只是监控机器上的资源,因此,我只启用18岁及以上的资源。 如果您还没有监控解决方案,请同时为17启用警报。 错误17表示一条语句导致SQL Server资源不足。
Full documentation around the severities can be found here.
有关严重性的完整文档可在此处找到。
Error Severity |
What it indicates |
18 |
There is a problem with the database engine software. |
19 |
Noncon |