Database Reference
In-Depth Information
You can create a SQL Server alert to automate the following tasks:
•
Inform the DBA via e-mail, SMS text, or pager.
•
Execute the Blocking Analysis job to collect blocking information for ten minutes.
You can create the SQL Server alert from SQL Server Enterprise Manager by following these steps:
1.
In Management Studio, while still in the SQL Agent area of the Object Explorer, right-click
Alerts and select New Alert.
2.
On the General page of the new alert's Properties dialog box, enter the alert name
and other details, as shown in Figure
20-18
. The specific object you need to capture
information from for your instance is
Locks
(
MSSQL$GF2008:Locks
in Figure
20-18
). I chose
500ms
as an example of a stringent SLA that wants to know when queries extend beyond
that value.
Figure 20-18.
Entering the alert name and other details
1.
On the Response page, define the response you think appropriate, such as alerting an
operator.
2.
Return to the new alert's Properties dialog box by clicking OK.
3.
On the Response page, enter the remaining information shown in Figure
20-19
.
