DB Files

ozsoft.sap.Monitor.DependencyRollup.MSSQL.Availability (DependencyMonitor)

MS SQL DB Files Monitor - as a rollup of MS SQL DB Files Availability monitors

Knowledge Base article:

Summary

Rollup the health state of MS SQL Server Availability monitors (enabled)

Configuration

No configuration is required

Causes

Please refer to the causing MS SQL Server monitor

Resolutions

See the causing MS SQL Server monitor Resolution

Element properties:

Targetozsoft.sap.MSSQL
Parent MonitorSystem.Health.AvailabilityState
AlgorithmWorstOf
Source MonitorSystem.Health.AvailabilityState
Relationshipozsoft.sap.relationship.MSSQL_DBFile
CategoryOperations
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveFalse
RemotableTrue
AccessibilityPublic

Source Code:

<DependencyMonitor ID="ozsoft.sap.Monitor.DependencyRollup.MSSQL.Availability" Accessibility="Public" Enabled="true" Target="ozsoft.sap.MSSQL" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal" RelationshipType="ozsoft.sap.relationship.MSSQL_DBFile" MemberMonitor="Health!System.Health.AvailabilityState">
<Category>Operations</Category>
<Algorithm>WorstOf</Algorithm>
<MemberUnAvailable>Error</MemberUnAvailable>
</DependencyMonitor>