Home
  •  

Database Performance (rollup)

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

Rolls up database performance to instance.

Knowledge Base article:

Summary

This monitor rolls up overall performance health for the database.

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:

TargetMicrosoft.SQLServer.2008.DBEngine
Parent MonitorSystem.Health.PerformanceState
AlgorithmWorstOf
Source MonitorSystem.Health.PerformanceState
RelationshipMicrosoft.SQLServer.DBEngineHostsDatabase
CategoryPerformanceCollection
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveFalse
RemotableTrue
AccessibilityPublic

Source Code:

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

  <Category>PerformanceCollection</Category>

  <Algorithm>WorstOf</Algorithm>

  <MemberUnAvailable>Error</MemberUnAvailable>

</DependencyMonitor>