How to receive emails about problem situations

Governor uses SQL Server’s database mail feature to send emails about warnings, alerts and missing client responses. Before you can configure Governor’s mail settings, make sure you have configured SQL Server database mail first: https://msdn.microsoft.com/en-us/library/hh245116.aspx.  

Configuring the database mail profile

When you've configured database mail on the server, you can configure SQL Governor to use the mail profile:

1. Go to Settings: General.
2. Double-click on the Database mail profile name row.
3. Enter the name of your profile.
4. Click on Save changes.

Configuring warning and alert emails 

Alert mails are configured at the level of individual units (server/instance/database) and performance counters. For example, you could configure to receive emails for one particular server’s CPU usage only. To configure emails for a performance counter, do the following steps: 

1. Go to Settings: Metadata.
2. Select Person settings from the dropdown.
3. If your name and email are not already listed, click on Add new and add your details.
4. Make sure Send email alerts is checked.
5. Select Server settings from the dropdown.
6. Find the server for which you want to configure emails and click the Edit icon. If the unit you want to configure emails for is an instance or a database, edit the server under which it resides. 
7. Select your name from the Responsible dropdown.
8. Click the OK icon.
9. Go to Settings: Warnings and alerts.
10. Click on the server, instance or database for which you want to configure emails.
11. Select a category from the dropdown.
12. Find the performance counter from the list and set the thresholds.
13. If you want to receive emails about warnings, set Warning action to Send mail.
14. If you want to receive emails about alerts, set Alert action to Send mail.
15. Click Save. 

Configuring emails about missing data

If you want to receive emails when the client proxy cannot send data for some reason, make sure steps 1-8 of the previous list are completed and then do the following steps: 

1. Go to Settings: Watchdogs.
2. Select Send mail from the Action dropdown.
3. Click Save. 

The emails will be sent to the person selected as the responsible person for the server. For example, if the proxy fails to send data about an instance, Governor will send an email to the person who is responsible for that instance’s server.