| DisplayName | Description | ID | Target | Parent Monitor | Algorithm | Algorithm Parameter | Source Monitor | Relationship | Category | Enabled | Alert Generate | Alert Severity | Alert Priority | Alert Auto Resolve | Remotable | Accessibility |
| Appliance Availability Rollup | This monitor rolls up the PDW Appliance availability health to the Watcher Node computer. | Microsoft.SQLServerAppliance.PDW2.Appliance.AvailabilityRollup | Microsoft.SQLServerAppliance.PDW2.ApplianceWatcherSeed | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServerAppliance.PDW2.ApplianceWatcherSeedHostsAppliance | AvailabilityHealth | True | False | | | False | True | Public |
| Components Availability Rollup | This monitor rolls up the Components availability health to the Components Group. | Microsoft.SQLServerAppliance.PDW2.Component.AvailabilityRollup | Microsoft.SQLServerAppliance.PDW2.ComponentGroup | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServerAppliance.PDW2.ComponentGroupContainsComponent | AvailabilityHealth | True | False | | | False | True | Public |
| Component Groups Availability Rollup | This monitor rolls up Component Groups availability health to the Appliance Node. | Microsoft.SQLServerAppliance.PDW2.ComponentGroup.AvailabilityRollup | Microsoft.SQLServerAppliance.PDW2.Node | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServerAppliance.PDW2.NodeContainsComponentGroup | AvailabilityHealth | True | False | | | False | True | Public |
| Compute Node Availability Rollup | This monitor rolls up the Compute Node availability health to the Microsoft SQL Server 2012 Parallel Data Warehouse. | Microsoft.SQLServerAppliance.PDW2.ComputeNode.AvailabilityRollup | Microsoft.SQLServerAppliance.PDW2.Appliance | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServerAppliance.PDW2.ApplianceContainsComputeNode | AvailabilityHealth | True | False | | | False | True | Public |
| Control Node Availability Rollup | This monitor rolls up the Control Node availability health to the Microsoft SQL Server 2012 Parallel Data Warehouse. | Microsoft.SQLServerAppliance.PDW2.ControlNode.AvailabilityRollup | Microsoft.SQLServerAppliance.PDW2.Appliance | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServerAppliance.PDW2.ApplianceContainsControlNode | AvailabilityHealth | True | False | | | False | True | Public |
| Host Node Availability Rollup | This monitor rolls up the Host Node availability health to the Host Nodes Cluster. | Microsoft.SQLServerAppliance.PDW2.HostNode.AvailabilityRollup | Microsoft.SQLServerAppliance.PDW2.HostNodesCluster | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServerAppliance.PDW2.HostNodesClusterContainsHostNode | AvailabilityHealth | True | False | | | False | True | Public |
| Host Nodes Cluster Availability Rollup | This monitor rolls up the Host Nodes Cluster availability health to the Host Nodes Clusters Group. | Microsoft.SQLServerAppliance.PDW2.HostNodesCluster.AvailabilityRollup | Microsoft.SQLServerAppliance.PDW2.HostNodesClustersGroup | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServerAppliance.PDW2.HostNodesClustersGroupContainsHostNodesCluster | AvailabilityHealth | True | False | | | False | True | Public |
| Host Nodes Clusters Group Availability Rollup | This monitor rolls up the Host Nodes Clusters Group availability health to the Microsoft SQL Server 2012 Parallel Data Warehouse. | Microsoft.SQLServerAppliance.PDW2.HostNodesClustersGroup.AvailabilityRollup | Microsoft.SQLServerAppliance.PDW2.Appliance | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServerAppliance.PDW2.ApplianceContainsHostNodesClustersGroup | AvailabilityHealth | True | False | | | False | True | Public |
| Management Node Availability Rollup | This monitor rolls up the Management Node availability health to the Microsoft SQL Server 2012 Parallel Data Warehouse. | Microsoft.SQLServerAppliance.PDW2.ManagementNode.AvailabilityRollup | Microsoft.SQLServerAppliance.PDW2.Appliance | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServerAppliance.PDW2.ApplianceContainsManagementNode | AvailabilityHealth | True | False | | | False | True | Public |