Home
  •  

MSSQL on Windows Replication: Database Performance Rollup

Microsoft.SQLServer.Replication.Windows.DependencyMonitor.Distributor.SystemDatabaseRollup (DependencyMonitor)

This monitor rolls up the performance state from Database to Microsoft SQL Server on Windows Replication

Knowledge Base article:

Summary

This monitor rolls up the performance state from Database to Microsoft SQL Server on Windows Replication.

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.Replication.Windows.Distributor
Parent MonitorSystem.Health.PerformanceState
AlgorithmWorstOf
Source MonitorSystem.Health.PerformanceState
RelationshipMicrosoft.SQLServer.Replication.Windows.Discovery.DistributorRefersSystemDatabase
CategoryPerformanceCollection
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveFalse
RemotableTrue
AccessibilityInternal

Source Code:

<DependencyMonitor ID="Microsoft.SQLServer.Replication.Windows.DependencyMonitor.Distributor.SystemDatabaseRollup" Accessibility="Internal" Enabled="true" Target="Microsoft.SQLServer.Replication.Windows.Distributor" ParentMonitorID="Health!System.Health.PerformanceState" Remotable="true" Priority="Normal" RelationshipType="Microsoft.SQLServer.Replication.Windows.Discovery.DistributorRefersSystemDatabase" MemberMonitor="Health!System.Health.PerformanceState">

  <Category>PerformanceCollection</Category>

  <Algorithm>WorstOf</Algorithm>

  <MemberUnAvailable>Error</MemberUnAvailable>

</DependencyMonitor>