Rolls up all user databases performance monitors to the server.
This monitor is the rollup of performance monitoring for all user databases hosted on this server. If the state is unknown, the monitoring has not been initialized yet.
Unhealthy state for this monitor indicates a problem with performance of user databases hosted on this server. View all current alerts for this server using this link:
<navigationLink xmlns="http://schemas.microsoft.com/maml/2004/10"> <linkText>View Alerts</linkText> <uri href="Microsoft.SystemCenter.AlertView&viewtarget={$TARGET$}" condition="View" uri="MOM.Console.Exe" /> </navigationLink>
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.
Target | Microsoft.SqlServer.Azure.Server |
Parent Monitor | System.Health.PerformanceState |
Algorithm | WorstOf |
Source Monitor | System.Health.PerformanceState |
Relationship | Microsoft.SqlServer.Azure.ServerHostsUserDatabase |
Category | PerformanceHealth |
Enabled | True |
Alert Generate | False |
Alert Auto Resolve | False |
Remotable | True |
Accessibility | Public |
<DependencyMonitor ID="Microsoft.SqlServer.Azure.Rollup.UserDatabaseToServerPerformance" Target="Microsoft.SqlServer.Azure.Server" ParentMonitorID="Health!System.Health.PerformanceState" RelationshipType="Microsoft.SqlServer.Azure.ServerHostsUserDatabase" MemberMonitor="Health!System.Health.PerformanceState" Accessibility="Public" Enabled="true" Remotable="true" Priority="Normal">
<Category>PerformanceHealth</Category>
<Algorithm>WorstOf</Algorithm>
<MemberUnAvailable>Error</MemberUnAvailable>
</DependencyMonitor>