Home
  •  

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 - monitoring has not been initialized yet.

Causes

An unhealthy state for this monitor indicates some 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.

Element properties:

TargetMicrosoft.SqlServer.Azure.Server
Parent MonitorSystem.Health.PerformanceState
AlgorithmWorstOf
Source MonitorSystem.Health.PerformanceState
RelationshipMicrosoft.SqlServer.Azure.ServerHostsFederation
CategoryPerformanceHealth
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveFalse
RemotableTrue
AccessibilityPublic

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="true" Remotable="true" Priority="Normal">

  <Category>PerformanceHealth</Category>

  <Algorithm>WorstOf</Algorithm>

  <MemberUnAvailable>Error</MemberUnAvailable>

</DependencyMonitor>