Page History
The Alert Templates window allows you to configure generic alert settings that you can apply to servers and groups of servers in your organization. An event that causes a metric to no longer meet a condition or to exceed a threshold signals SQL Diagnostic Manager to raise an alert. The Alert templates Templates save you time and help you to avoid mistakes by simplifying alert configuration across your environment.
SQL Diagnostic Manager displays the default template name and description in bold text.has the following five Alert Templates that can be used to configure generic alert settings to apply to your monitored servers:
- Default Template
- Critical-Only Template
- Performance Template
- Amazon RDS DBaaS Template
- Azure SQL DBaaS Template
Applying an alert template to a monitored server overwrites all existing alert configurations. You can make any custom changes to the specific server's alert configuration once the template is applied. If you make a change to a template that is applied to a server, you must also reapply the template to that server using the Apply To button.
...
A template allows you to apply the same alert configurations to more than one SQL Server SQL Server instance. It helps you avoid simple mistakes such as transposing characters or leaving out metric details that could occur when you manually configure each server. Alert templates also help you roll out changes by making the updates in a single location and then rolling out the changes across your environment. If you are more interested in ad hoc alert configuration, remember that you can use a template to return a server to default settings if you make any changes that you later want to revert.
Access the Alert Templates window
You can open the Alert Templates window from the SQL Diagnostic Manager Console menu bar by selecting Tools > Alert > Alert Configuration Templates.
Create a new alert
...
templateTest
Create a new alert template or edit the existing Default Template to suit your needs when alerting on your monitored SQL Server SQL Server instances.
To create a new alert template:
- Select Tools > Alert Configuration Templates.
- Click New.
- Type a unique name and description.
- If you want to create a new template based on an existing template , select the name of the existing template from the Copy from list.
- If you want to use this new template as your default template , check Default Template.
- Click OK when done.
- If you want When you click OK, the "Would you like to apply this new template to your existing SQL Server instances, click Yes in the confirmation message box. If SQL Server instances?" message prompts. Click Yes to confirm or click No if you do not want to apply this template.
- If you click Yes, the Select Servers or Tags opens. Select Tags or Select Servers to which the alert template should be applied.
| Info |
|---|
| You can edit the configuration of your new alert template |
...
| . In the Add Alert Template window, click Edit configuration to change thresholds and other metric parameters, for more information review Configure your alert settings |
...
| . |
Change an existing template
...
SQL Diagnostic Manager allows you to export an existing alert template. Select the template from the list, and then click Export. You can use the default location or specify a different path to save the export file.
Apply template changes to a tag or server
...
SQL Diagnostic Manager includes the ability to apply some alert thresholds on a per-database or per-disk basis within an instance. When you create an alert template and include one of these alerts, you cannot select which database or disk to apply the alert to because that is unknown in a template. For that reason, these alerts apply to all databases and disks within the instance to which it is applied.