Submit a ticketCall us

Training ClassSign up for Network Performance Monitor (NPM) and Scalability instructor-led classes

Attend our instructor-led classes, provided by SolarWinds® Academy, to discuss the more advanced monitoring mechanisms available in NPM as well as how to tune your equipment to optimize its polling capabilities. NPM classes offered:
NPM Custom Monitoring and Polling
Orion Platform Scalability

Reserve your seat.

Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > AppInsight for SQL: Database status is not calculated correctly in all cases

AppInsight for SQL: Database status is not calculated correctly in all cases

Overview

This article provides brief information and steps to resolve the issue when the Database status is not correctly calculated in all cases.

After a successful poll, the application results in a status Down even when the database is in the Up state. Also, child components are reported as being Down.
 

Environment

All SAM versions

 

Cause

The issue is caused when the AutoClose flag on the SQL database is enabled. 

Resolution

Disable the AutoClose flag on the SQL database. 

 

 

 

Last modified

Tags

Classifications

Public