Applies to: SQL Agent Insight version 0.23

Preferences

At anytime while running SQL Agent Insight, clicking on the Preferences toolbar button or by pressing CTRL+ALT+C key sequence will open the preferences dialog.

The General tab

SHOW SYSTEM TRAY NOTIFICATIONS
When enabled, SQL Agent Insight will send notifications to Window’s notification panel.

SHOW DASHBOARD ON STARTUP
Opens the dashboard immediately on startup of SQL Agent Insight.

OVERRIDE APPLICATION NAME IN SQL CONNECTION STRING
For any connection made to the SQL instance via a connection string, the application name is replaced by this string.
By default, it is product name along with the version number.
If left blank/empty, .NET will replace substitute the string “.Net SqlClient Data Provider” in it’s place.
The Reset button will overwrite the current configured string and reset it back to the product name and version number.

■ PRO TIP

If other SQL monitoring software is tracking application connections to the instance, changing the connection string could be used to disguise the operation of SQL Agent Insight.

PREVENT SYSTEM FROM ENTERING SLEEP MODE OR INVOKING THE SCREENSAVER
When enabled, this setting will prevent the client system running SQL Agent Insight from going into sleep mode and prevent the screensaver from activating.

■ PRO TIP

Preventing the system from entering sleep mode is ideal for users, e.g. a helpdesk, that has the continually monitor the dashboard.

START INSIGHTS IN MAINTENANCE MODE
When enabled, all metrics will immediately be in maintenance mode.

■ PRO TIP

Starting Insights in maintenance mode is useful on the occasion whereby metric thresholds have not yet been configured, preventing alarms and possibly email notifications from firing.

The Notifications tab

The Notifications tab has the following options:

ENABLE GLOBAL E-MAIL NOTIFICATIONS
When enabled, this allows the configuration of all other email settings on the form all fully allows email notifications from SQL Agent Insight.
If this option is disabled, no email notifications will be sent from SQL Agent Insight, even if individual Insights have notifications turned on.

OUTGOING SMTP SERVER

  • Enable SSL/TLS
    • When enabled, connections to the outgoing SMTP server will use SSL/TLS encryption.

  • Name or IP
    • Enter the outgoing SMTP fully qualified domain name (FQDN) or it’s IP address.

  • Port
    • Specify the outgoing SMTP server port, by default this will be port 25.
    • However, for Google for example, use 465 or 587. 

AUTHENTICATION

  • Username/Mailbox
    • Enter the username or mailbox identifier to connect to the SMTP service with.

  • Password
    • Specify the password for the username or mailbox identifier above.
■ NOTE

The password is stored in the settings file of SQL Agent Insight and is encrypted.

MAIL MESSAGE SETTINGS

  • From
    • Specify the ‘from’ email address as it will appear in the email client. Note that most outgoing SMTP servers will require the email address domain name to be the same as the outgoing SMTP server name above.

  • To
    • Specify all email addresses in which to notify via email notifications.
      Separate multiple email addresses with a comma.

  • CC
    • (Optional) – Specify all email addresses in which to carbon-copy via email notifications.
      Separate multiple email addresses with a comma.

  • Message body in HTML format
    • When enabled, the message body format will be in HTML format. When disabled, the message body format will be plain text.

  • Send Test Email
    • Clicking this button will send a test email using all of the settings specified above. The outcome of the test will be displayed in the Preferences status bar.

OK (button)

  • Upon changing any setting, the status bar of the Preferences dialog will change and notify the user Changes Detected. Click OK to save and apply. Pressing the OK button will do just that, then promptly close the Preferences dialog.

CANCEL (button)

  • Pressing the Cancel button will do just that, close the Preferences dialog and any pending changes are not applied.