Wednesday, 20 February 2013

Create a SQL Server Performance Condition alert

we will configure SQL Server Agent to transmit an alert if the number of connections is above 50 and alert the operator Operator_admin when it happens

  •  In Object Explorer, expand SQL Server Agent, right-click Alerts, and then click New Alert.
  • In the New Alert dialog box, add a new alert with the properties in the following table.
  • Configure the alert as below :

Name: Sql Server Performance alert
Type: Sql server Performance Condition alert
Object: Sql server General Statistics
Counter: User connections
Alert if counter rises above: 50

  • In The Response Panel select the Notify operators check box, and then select the E-mail check box for the Operator_Admin operator
  • On the Options page, select the E-mail check box, in the Additional notification message to send box, type Warning: The number of user connections has exceeded 50 on the instance NamedInstance, and then click OK.

No comments:

Post a Comment