Page History
Use the Alert Response window to create or modify your new alert response rule.
Anchor ARActions ARActions
Access the Alert Response window
ARActions | |
ARActions |
- Select Tools > Alert Actions and Responses. Click
Add
...
Add a new rule
- Click Add on the Alert Responses tab of the Alert Actions and Responses dialog box.
- Enter a Name for the rule.
- Check the boxes for the conditions and destinations for the rule.
- Click Enable to activate the associated action. Note that all actions are disabled by default.
- If you enabled an action, provide any required information for the selected action.
- Click Add to select additional actions to perform in response to the alert. This feature allows you to add multiple instances of certain actions.
- Click the hyperlink text to select specific conditions for the rule.
- Click OK when finished.
...
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.
Where the SQL Server Instance is in specified list
Trigger a response when the listed SQL Server instance is included in the displayed list. Click specified list, and and then select one or more instances to include in the alert response trigger. Click Select all to include all of the displayed instances.
Where SQL Server Instance has a tag in specified list
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.
Where the metric is in the specified list
Trigger a response if the metric is included in the displayed list. Click metric, and and then select one or more metrics to include in the alert response trigger. Click Select all to include all of the displayed metrics.
Where all metrics are in the specified list
Trigger a response only if multiple metrics in the specified list reach a critical thresholdthe specified threshold(s). Click metric, and and then select metrics to include in the alert response trigger. Click Select all to include all of the displayed metrics.
Where metric severity has changed
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.
Where refresh occurred during a specific time frame
Trigger a response if the refresh occurred during the displayed time frame. Click during this time, and and then select the time and date range to set the alert response trigger time frame.
Anchor AvailableAction AvailableAction
Available action providers
AvailableAction | |
AvailableAction |
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 click Enable next to the appropriate action. The following actions help you manage alert response rules:
- Email (SMTP) Provider Provider
- EventLog Action Provider
- Network Management Protocol (SNMP) Trap Message Provider
- PowerShell Action Provider
- Prescriptive Analyzer Action Provider
- Program Action Provider
- Query Monitor Action Provider
- Query Waits Action Provider
- EventLog SCOM Alert Action Provider
- Network Management Protocol (SNMP) Trap Message SCOM Event Action Provider
- Program ServiceNow Action Provider
- SQL Agent Job Action Provider
- SQL Script Action Provider
- To Do Action Provider
Anchor emailprovider emailprovider
Email (SMTP) Provider
emailprovider | |
emailprovider |
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 and network manager settingsto to receive these alert email messages.
Anchor
...
eventlogap
eventlogap |
...
eventlogap
eventlogap |
...
EventLog Action Provider
...
When the criteria for the new alert rule is met,
...
an entry to the EventLog is created.
Anchor networkprovider networkprovider
Network Management Protocol (SNMP) Trap Message Provider
networkprovider | |
networkprovider |
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.
Anchor powershellap powershellap
PowerShell
powershellap | |
powershellap |
...
To enable the prescriptive analyzer as an alert response:
- Enable the Prescriptive Analyzer provider, and the Prescriptive Analysis Settings window displays.
- Select the performance categories of your choice.
- Click OK.
...
Action Provider
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
...
To enable query monitor as an alert response:
- Enable the Query Monitor PowerShell Action provider and the Query Monitor Settings dialog displays. PowerShell Action dialog displays.
- Enter a description for the PowerShell command in the Description field.
- Either type in the PowerShell command you want to run when the alert criteria is met, or paste in the PowerShell command from another application.
- Click Test to verify your PowerShell commandSelect either Enable query monitor to enable the query monitor until it is manually disabled or Enable query monitor for a limited time.
- Click OK.
Anchor
...
prescriptiveprovider
prescriptiveprovider |
...
prescriptiveprovider
prescriptiveprovider |
...
Prescriptive Analyzer Action Provider
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:
- Enable the Prescriptive Analyzer provider and the Prescriptive Analysis Settings window displays.
- Select the performance categories of your choice.
- Click OK
...
- .
Anchor programprovider programprovider
Program Action Provider
programprovider | |
programprovider |
When 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:
- Enable the Program Action provider and the Program Action dialog displays.
- Enter a description for the Program action.
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.
Tip You can run executable (.exe) files only through the Program Action Provider. If you need to run a batch (.bat) file, use
cmd /c run.bat.
Enter the full path of the directory in which you want the program to run.
Tip The Start in field is useful when you want a different directory for where an action begins and where the program resides.
- Click Test to make sure that the SQLdm Management Service can run the program.
- Click OK.
Anchor querymonitorap querymonitorap
Query Monitor Action Provider
querymonitorap | |
querymonitorap |
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:
- Enable the Query Monitor provider and the Query Monitor Settings dialog displays.
- Select either Enable query monitor to enable the query monitor until it is manually disabled or Enable query monitor for a limited time.
- Click OK.
Anchor querywaitsap querywaitsap
Query Waits Action Provider
querywaitsap | |
querywaitsap |
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:
- Enable the Query Waits provider and the Query Waits Settings dialog displays.
- Select either Enable query waits to enable the query monitor until it is manually disabled or Enable query waits for a limited time and configure the duration.
- Click OK.
Anchor scomalert scomalert
SCOM Alert Action Provider
scomalert | |
scomalert |
When the criteria for the new alert rule is met, SQL Diagnostic Manager sends an alert to SCOM.
To create SCOM alert response:
- Send to SCOM as Alert option.
- Select the metrics you want to be sent to SCOM as alerts. You can also select all available metrics.
- Click OK.
Anchor scomevent scomevent
SCOM Event Action Provider
scomevent | |
scomevent |
When the criteria for the new alert rule is met, SQL Diagnostic Manager sends an event to SCOM.
To create SCOM alert response:
- Send to SCOM as Event option.
- Select the metrics you want to be sent to SCOM as alerts. You can also select all available metrics.
- Click OK.
Anchor servicenow servicenow
ServiceNow Action Provider
servicenow | |
servicenow |
When the criteria for the new alert rule is met, SQL Diagnostic Manager sends an alert to ServiceNow.
To enable ServiceNow as an event:
- Enable Send ServiceNow as Event option.
- Provide the following information regarding the ServiceNow configuration:
- Provider Name. By default, ServicerNow Action Provider
- URL. For now, use the following link:
https://instancename.service-now.com - Upload As. Select Event from the drop-down list.
- User Information
- Username.
- Password.
- Alert Source. By default, SQL Diagnostic Manager.
- Click OK.
To enable ServiceNow as an alert:
- Enable Send ServiceNow as Alert option.
- Provide the following information regarding the ServiceNow configuration:
- Provider Name. By default, ServicerNow Action Provider
- URL. For now, use the following link:
https://instancename.service-now.com - Upload As. Select Alert from the drop-down list.
- Table Name. Type the desired table name in the text field.
- User Information
- Username.
- Password.
- Alert Source. By default, SQL Diagnostic Manager.
- Click OK.
Info |
---|
Keep in mind that you should have an evt_mgmt_operator and soap user role for basic authentication for ServiceNow integration. |
Info |
---|
Consider that the Provider Name and the Alert Source are descriptive fields. You can leave them with default values or edit them to your preference. |
Anchor sqlagentjob sqlagentjob
SQL Agent Job Action Provider
sqlagentjob | |
sqlagentjob |
When the criteria for the new alert rule is met, you can specify a SQL Agent Job to run in response to the alert.
...
- Enable the SQL Agent Job Action provider and the SQL Agent Job Action dialog displays.
- Select the SQL Server instance from the Server drop-down list or select %(Instance) to run the SQL Agent Job on the server that caused the alert.
- Click Browse next to the Job Name field.
- On the Select Job window, select the SQL Server instance the SQL Agent Job is located on and click Load.
- Select the SQL Agent job from the list and click OK.
- If you want to select a particular Job Step to run, click the Browse button in the Job Step window
- In the Select Job Step window click Load.
- Select the Job step from the list and click OK.
- Click Test to verify your configuration.
- Click OK.
Anchor sqlscriptprovider sqlscriptprovider
SQL Script Action Provider
sqlscriptprovider | |
sqlscriptprovider |
When the criteria for the new alert rule is met, you can specify a SQL Server script to run in response to the alert.
...
- Enable the SQL Script Action provider and the SQL Script Action dialog displays.
- Enter a description for the SQL Script Action in the Description field.
- Click Browse to select the SQL Server instance or leave it at the default of %(Instance) to run the SQL Script on the server that caused the alert.
- Either type in the T-SQL you want to run when the alert criteria is met , or paste in the T-SQL from another application.
- Click Test to verify your SQL script.
- Click OK.
...
Change the condition value
You can edit the rule description by clicking the underlined value from the Step 3 section.
...
When the criteria for the new alert rule is met, a To Do list item is created.
To create a To Do as an alert response:
- Enable the To Do action provider.
- Click the someone text in the Select Actions field.
- Enter the users to assign the To Do in the Users field.
- Enter a custom message in the Message field or accept the default text.
- Click OK.
Warning |
---|
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. |
Change the condition value
Click the underlined value and 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.
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...
...