Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > Instance availability alert does not trigger

Instance availability alert does not trigger

Created by Jamin Walters, last modified by Rodim Suarez_ret on Mar 08, 2017

Views: 295 Votes: 0 Revisions: 4

Updated March 8, 2017

Overview

The database instance availability alert is configured for a short interval such as 1 minute. When the instance goes down, the alert is not firing or does not trigger for a while after the instance is not connected. 

Environment

All DPA versions

Cause 

This alert had a history of alerting and giving a false positive. It is based on us simply connecting to the instance but a few things have to be true for it to fire.

The monitor has to be on but, connection to the server is not working.

Then we also have a tolerance in the code where we sample every 90 seconds by default and if we have 3 attempts that fail 90 seconds apart we alert.

Resolution

This alert is configurable. You can set the interval that we pull as well as the number of fails for a pull.

Go to Options > Administration tab > Advanced Options > DB instance Options tab > select the instance you want to change from the drop down menu.

ALERT_CONNECTION_INTERVAL - default is 90 
ALERT_CONNECTION_ATTEMPTS - default is 3

Tune these settings to find the level of alert that works for your environment. This about finding the balance between false alerts and not alerting soon enough.

 

 

Last modified

Tags

Classifications

Public