Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

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