concept alert in category sql server

appears as: lerts, alert, n alert
SQL Server 2008 Administration in Action

This is an excerpt from Manning's book SQL Server 2008 Administration in Action.

  • Policy-based management— Arguably the most significant new SQL Server 2008 feature for the DBA, policy-based management dramatically simplifies the process of managing a large number of SQL Server instances through the ability to define and apply configuration policies. As you’ll see in chapter 8, changes that violate policy can either be prevented or generate alerts, with groups of servers and instances remotely reconfigurable at the click of a button.
  • Our focus will then shift to the importance of automation and its role in reducing errors and achieving more within the limited hours of a day. We’ll cover maintenance plans and SQL Server Agent jobs before looking at setting up alerts for error and performance conditions.

    Figure 14.22. You can create alerts for SQL Server events such as deadlocks or for performance counter thresholds such as this one for Batch Requests/sec.