Database Performance (rollup)

Microsoft.SQLServer.2014.DBEngine.DBPerformanceRollup (DependencyMonitor)

This monitor rolls up the performance state from Database to DB Engine.

Knowledge Base article:

Summary

This monitor rolls up the performance state from Database to DB Engine..

Overrideable Parameters

Name	Description	Default Value
Enabled		Yes
Generates Alerts		No

Element properties:

Target	Microsoft.SQLServer.2014.DBEngine
Parent Monitor	System.Health.PerformanceState
Algorithm	WorstOf
Source Monitor	System.Health.PerformanceState
Relationship	Microsoft.SQLServer.2014.DBEngineHostsDatabase
Category	PerformanceCollection
Enabled	True
Alert Generate	False
Alert Auto Resolve	True
Remotable	True
Accessibility	Public

Source Code:

<DependencyMonitor ID="Microsoft.SQLServer.2014.DBEngine.DBPerformanceRollup" Accessibility="Public" Target="SQL2014Core!Microsoft.SQLServer.2014.DBEngine" Enabled="true" ParentMonitorID="SystemHealth!System.Health.PerformanceState" RelationshipType="SQL2014Core!Microsoft.SQLServer.2014.DBEngineHostsDatabase" MemberMonitor="SystemHealth!System.Health.PerformanceState">

  <Category>PerformanceCollection</Category>

  <Algorithm>WorstOf</Algorithm>

  <MemberUnAvailable>Error</MemberUnAvailable>

</DependencyMonitor>