Home
  •  

Dependency monitor on SQL Data Tier

TeamFoundationServer2008.TFSDataTierInstance (DependencyMonitor)

Dependency monitor on SQL Instance - Data Tier

Knowledge Base article:

Summary

This monitor rolls up the SQL Data Tier instance state onto the Application Tier.

Causes

There could be any number of causes. Overall this is serious error as this means TFS is unavailable as the Data Tier is down

Resolutions

Check the dependent monitor for the SQL Instance on the Health Explorer to know the real reason.

Element properties:

TargetTeamFoundationServer2008.TFSApplicationTier
Parent MonitorSystem.Health.AvailabilityState
AlgorithmWorstOf
Source MonitorSystem.Health.AvailabilityState
RelationshipTeamFoundationServer2008.TFSATtoTFSDBInstance
CategoryCustom
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityHigh
Alert Auto ResolveTrue
RemotableTrue
AccessibilityInternal
Alert Message
Dependency monitor for roll up of Data Tier Instance health
Teh Data Tier (Database Instance) associated to this Application Tier is unavailable. Please check into the specific SQL Instance for the problem.

Source Code:

<DependencyMonitor ID="TeamFoundationServer2008.TFSDataTierInstance" Accessibility="Internal" Enabled="true" Target="TeamFoundationServer2008.TFSApplicationTier" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal" RelationshipType="TeamFoundationServer2008.TFSATtoTFSDBInstance" MemberMonitor="Health!System.Health.AvailabilityState">

  <Category>Custom</Category>

  <AlertSettings AlertMessage="TeamFoundationServer2008.TFSDataTierInstance_AlertMessageResourceID">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>High</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

  </AlertSettings>

  <Algorithm>WorstOf</Algorithm>

  <MemberUnAvailable>Error</MemberUnAvailable>

</DependencyMonitor>