Database Performance (rollup)

Microsoft.SQLServer.2016.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	Enables or disables the workflow.	Yes
Generates Alerts	Defines whether the workflow generates an Alert.	No

Element properties:

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

Source Code:

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

  <Category>PerformanceCollection</Category>

  <Algorithm>WorstOf</Algorithm>

  <MemberUnAvailable>Error</MemberUnAvailable>

</DependencyMonitor>