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 save you time and help you to avoid mistakes by simplifying alert configuration across your environment. 

SQL Diagnostic Manager has the following five Alert Templates that can be used to configure generic alert settings to apply to your monitored servers:

...

A template allows you to apply the same alert configurations to more than one multiple SQL Server instanceinstances. 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.

...

You can open the Alert Templates window from the SQL Diagnostic Manager Console menu bar by selecting Image Removedselecting Image Added > Alert Configuration Templates.

...

To create a new alert template:

1. Select Image Removed and Select Image Added and click Alert Configuration Templates.
2. Click New.
3. Type a unique name and description.
4. 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.
5. If you want to use this new template as your default template, check Default Template.
6. When you click OK, the "Would you like to apply this template to existing SQL Server instances?" message prompts. Click Yes to confirm or click No if you do not want to apply this template.
   
   1. If you click Yes, the Select Servers or Tags opens. Select Tags or Select Servers to which the alert template should be applied.

...

SQL Diagnostic Manager allows you to make changes to an existing alert template. Select the template from the list, and then click View/Edit. If necessary , you can delete any existing template except for the Default Template. To delete a template, select the template you want to delete, and then click Delete.

...

Once you create a new template or make changes to change an existing templateone, you should apply the updates to your tags or servers. Select the template from the list, click Apply To, select a tag or servers to which you want to apply the alert template, and then click OK.

Note that if the template you are making make changes to is already associated with a tag or server, these changes are not automatically applied when you change the template. You must use the the Apply To button and select the appropriate tag or servers.

...

You can set an existing template as the default for SQL Diagnostic Manager to apply to all new servers added without specifying an alert template. To designate a template as the default, click the template in the list, click Set Default, and then click OK. If there is only one template in your list , SQL Diagnostic Manager uses this template as the default.

...