DB Files

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

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

Knowledge Base article:

Summary

Rollup the health state of MS SQL Server performance 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.PerformanceState
AlgorithmWorstOf
Source MonitorSystem.Health.PerformanceState
Relationshipozsoft.sap.relationship.MSSQL_DBFile
CategoryOperations
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveFalse
RemotableTrue
AccessibilityPublic

Source Code:

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