Page History
...
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:
- Email (SMTP) Provider
- Prescriptive Analyzer Action Provider
- Query Monitor Action Provider
- SCOM Alert Action 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
- Email (SMTP) SCOM Alert Action Provider
- SCOM Event Action Provider
- SQL Agent Job Action Provider
- SQL Script Action ProviderQuery Waits Action Provider
- PowerShell Action Provider
Anchor
...
emailprovider
| emailprovider |
...
emailprovider
Email (SMTP)
| emailprovider |
...
Provider
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.
Anchor eventlogap eventlogap
EventLog
| eventlogap | |
| eventlogap |
...
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, it triggers the Query Monitor to start so that you can collect more information.
To enable query monitor as an alert response:
...
an entry to the EventLog is created.
Anchor
...
networkprovider
| networkprovider |
...
networkprovider
Network Management Protocol (SNMP) Trap Message Provider
| networkprovider |
When the criteria for the new alert rule is met, SQL Diagnostic Manager sends an
...
To create SCOM alert response:
...
SNMP Trap message to the network management console based on the configuration of your email settings and network management settings.
Anchor
...
powershellap
| powershellap |
...
powershellap
| powershellap |
...
PowerShell 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 as an alert response:
- Enable the PowerShell Action provider and the 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 command.
- Click OK.
Anchor
...
prescriptiveprovider
| prescriptiveprovider |
...
prescriptiveprovider
Prescriptive Analyzer Action
| prescriptiveprovider |
...
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 |
...
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 |
...
querymonitorap
Query Monitor Action
| querymonitorap |
...
Provider
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. 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 |
...
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.
...
- 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.
...
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.
...
- script
...
To run a PowerShell script as an alert response:
- Enable the PowerShell Action provider and the 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 command.
- Click OK.
...
- .
Change the condition value
...