Use the Alert Response window to create or modify your new alert response rule.
By default, alert response rules are not limited to specific SQL Server instances, metrics, severity levels, and times. You can use conditions to tailor the triggers of your alert responses. The following conditions help you manage alert response rules.
Trigger a response when the listed SQL Server instance is included in the displayed list. Click specified list, and then select one or more instances to include in the alert response trigger. Click Select all to include all of the displayed instances.
Trigger a response when the listed SQL Server instance contains a tag in the displayed list. Click specified list, and then select one or more tags to include in the alert response trigger. Click Select all to include all of the displayed tags.
Trigger a response if the metric is included in the displayed list. Click metric, and then select one or more metrics to include in the alert response trigger. Click Select all to include all of the displayed metrics.
Trigger a response only if multiple metrics in the specified list reach the specified threshold(s). Click metric, and then select metrics to include in the alert response trigger. Click Select all to include all of the displayed metrics.
Trigger a response when the metric severity changes regardless of level. Click the displayed severity level, and then select one or more severity levels to include in the alert response trigger.
Trigger a response if the refresh occurred during the displayed time frame. Click during this time, and then select the time and date range to set the alert response trigger time frame.
Action providers allow you to select actions that you want to occur as part of the alert response. By default, all actions are disabled. To enable an action, click Enable next to the appropriate action. The following actions help you manage alert response rules:
When the criteria for the new alert rule is met, it triggers the Prescriptive Analyzer to run a prescriptive analysis on a specific server based on selected performance categories.
To enable the prescriptive analyzer as an alert response:
When the criteria for the new alert rule is met, it triggers the Query Monitor to start so that you can collect more information.
To enable query monitor as an alert response:
When the criteria for the new alert rule is met, SQL Diagnostic Manager sends an alert to SCOM.
To create SCOM alert response:
When the criteria for the new alert rule is met, an entry to the EventLog is created.
When the criteria for the new alert rule is met, SQL Diagnostic Manager sends an SNMP Trap message to the network management console based on the configuration of your email settings and network management settings.
When the criteria for the new alert rule is met, you can specify a program for the SQLdm Management Service to run in response to the alert.
To start a program as an alert response:
Enter the full path to the program you want to launch as an alert response. Use the More Options drop-down menu to select from common runtime arguments.
You can run executable (.exe) files only through the Program Action Provider. If you need to run a batch (.bat) file, use |
Enter the full path of the directory in which you want the program to run.
The Start in field is useful when you want a different directory for where an action begins and where the program resides. |
When the criteria for the new alert rule is met, SQL Diagnostic Manager sends an alert email message to the SMTP server, which then forwards the message to the specified email address. Configure your email settings and network manager settings to receive these alert email messages.
When the criteria for the new alert rule is met, SQL Diagnostic Manager sends an event to SCOM.
To create SCOM alert response:
When the criteria for the new alert rule is met, you can specify a SQL Agent Job to run in response to the alert.
To start a SQL Agent Job as an alert response:
When the criteria for the new alert rule is met, you can specify a SQL Server script to run in response to the alert.
To run a SQL Script Action Provider as an alert response:
When the criteria for the new alert rule is met, it triggers the Query Waits to start so that you can collect more information.
To enable query waits as an alert response:
When the criteria for the new alert rule is met, you can specify a PowerShell script to run in response to the alert.
To run a PowerShell script as an alert response:
After you create a new rule, you can then create a ToDo item and assign it to specific users for when the conditions configured in your notification rule are met. Note that beginning with SQL Diagnostic Manager 7.0, the To Do feature is available only to users who had To Do activated in an earlier 6.x version. This version of SQL Diagnostic Manager does not support this feature for new users. |
You can edit the rule description by clicking the underlined value from the Step 3 section. SQL Diagnostic Manager displays a list of currently defined items for you to select as the new value. Make the necessary updates, and then click OK.
IDERA Website | Products | Purchase | Support | Community | About Us | Resources | Legal |
---|