Working with email notifications and email profiles in ApexSQL monitoring tools

Applies to
ApexSQL Monitor, ApexSQL BI Monitor, ApexSQL VM Monitor

Summary
This article explains how to properly set email notifications for raised alerts and how to create and use the email profiles

Description

All ApexSQL monitoring tools can be set to send an email whenever an alert is raised or summary emails in regular intervals for alerts raised during that interval. Email notification behavior is fully configurable and all monitoring tools can be set to:

  • send an email for every type of alert
  • not send emails at all
  • send emails only for those alerts considered important
  • send summary email for user defined period of time

Once the basic email notification settings have been set up, configured email notifications at a more granular level is recommended, like using a different recipient for particular alerts, or sending multiple email notifications to different users for one or more types of alert.

Information included in email alert is:

  • the computer name and object against which alert has been raised
  • the metric and severity level
  • the metric value at which the alert has been raised
  • the time and date when the raised alert was logged

Here is an example of the email alert text:

A high alert has been raised for server SERVER2012R2

Metric ‘Utilization of processor time’

– Value: 95 %

– Measured at: 11/16/2014 10:45:39 AM -08:00

There are four steps in setting up an email notification:

  1. Configuring SMTP profiles
  2. Configuring email profiles
  3. Creating the appropriate alert action
  4. Selecting the desired email profile in the configure metrics page

Setting up an SMTP server for alerting

Open the AdministrationSMTP settings page and press the Add button. The Add SMTP settings page will be displayed

Quick tip icon

Quick tip:

Select SSL authentication to enable explicit SSL email. Once the SMTP connection is established, SSL is requested and the message delivered using the supplied credentials. Check with administrator to find out whether mail server requires SSL authentication. If this is the case, selecting the SSL authentication check-box is required

Once the configuration data are filled, press the Test button to verify that the SMTP setting is configured properly. In the Select test recipient dialog, enter the valid email address and press OK

If SMTP server is configured properly, the test email should arrive on the entered address

Setting up an email profile for alerting

Open the AdministrationEmail profiles page and press the Add button. The Add email profile page will be displayed

To set up an email profile:

  1. Enter the name for the email profile
  2. All text fields except cc: are required
  3. Select the existing SMTP profile from the drop-down menu
  4. Optionally, if no SMTP profiles are created, press the button to open the SMTP settings page and configure an SMTP server as described in the Setting up an SMTP server for alerting section

Press the Save button to save created profile

Creating an alert action to send email for triggered alerts

  1. Enter the name for the new alert action
  2. Select the Add email profile radio button
  3. In the Add alert action section, select the previously created email profile

The Send a summary email every xx minute(s) option will send a single mail in user defined time intervals with summary of all raised alerts for that time period. With this option, ApexSQL monitoring tools limit the number of emails sent to prevent excessive emails sent to the recipient’s mail server. This option is recommended for measurements that don’t require immediate action

The Send an email for each alert (alert severity can be selected) option will send an email immediately on every raised alert of the defined severity. This option is recommended for critical measurements where immediate action is required

When all the required information is entered, save the created profile by pressing the Save button and the new alert action for sending emails to selected email profile will be created

Configuring email notifications for specific alerts

The ConfigurationMetrics page allows selecting and assigning the saved alert action profile to each individual metrics, by picking up the profile in the Alert action drop-down menu. An email alert action profile can be assigned to the individual metrics only in case when alerting is enabled for that metric

Quick tip icon

Quick tip:

An alert action profile can be assigned to all available metrics at once by selecting it from the Alert action profile drop-down menu located in the Metrics window header. Via this option, the email profile will be also assigned to metrics with disabled alerting

To disable email alerting, select the first blank field from the Alert action drop down menu.

FAQs:

Q: Can an email profile be edited?

A: Yes, any email profile can be edited by selecting the button in the grid for the email profile that should be changed in the AdministrationEmail profiles page

Q: Is an email account/SMTP server required for setting up email profile?

A: Yes, both, a valid email account and a valid SMTP server are required. One email account and one SMTP server can be used for different email profiles.

Q: Which is the minimum period that can be set for sending an email summary?

A: The period for sending an email summary is expressed in minutes and its minimal value is 1 minute.