Federations Performance

Microsoft.SqlServer.Azure.Rollup.FederationToServerPerformance (DependencyMonitor)

Rolls up all federations’ performance monitors to the server.

Knowledge Base article:

Summary

This monitor is the rollup of performance monitoring for all federations hosted on this server. If the state is unknown, the monitoring has not been initialized yet.

Causes

Unhealthy state for this monitor indicates a problem with performance of federations hosted on this server. View all current alerts for this server using this link:

View Alerts

Resolutions

Use the health explorer to drill down and find the cause of the unhealthy state. Use the knowledge on the specific monitor causing the issue to troubleshoot and fix the problem.

Overrideable Parameters

Name	Description	Default Value
Enabled	Enables or disables the workflow.	No
Generates Alerts	Defines whether the workflow generates an Alert.	No

Element properties:

Target	Microsoft.SqlServer.Azure.Server
Parent Monitor	System.Health.PerformanceState
Algorithm	WorstOf
Source Monitor	System.Health.PerformanceState
Relationship	Microsoft.SqlServer.Azure.ServerHostsFederation
Category	PerformanceHealth
Enabled	False
Alert Generate	False
Alert Auto Resolve	False
Remotable	True
Accessibility	Public

Source Code:

<DependencyMonitor ID="Microsoft.SqlServer.Azure.Rollup.FederationToServerPerformance" Target="Microsoft.SqlServer.Azure.Server" ParentMonitorID="Health!System.Health.PerformanceState" RelationshipType="Microsoft.SqlServer.Azure.ServerHostsFederation" MemberMonitor="Health!System.Health.PerformanceState" Accessibility="Public" Enabled="false" Remotable="true" Priority="Normal">

  <Category>PerformanceHealth</Category>

  <Algorithm>WorstOf</Algorithm>

  <MemberUnAvailable>Error</MemberUnAvailable>

</DependencyMonitor>