Microsoft SQL Server 2016 Always On (Views)

Microsoft.SQLServer.2016.AlwaysOn.Views :: 7.0.7.0 (Management Pack)

This Management Pack contains views and folder structure for Microsoft SQL Server 2016 Always On management packs.

Management Pack Elements

Show Management Pack References

TypeDefinitions

EntityTypes

RelationshipType (10)

Monitoring

Discovery (8)
Monitors

DependencyMonitor (24)

Presentation

FolderItem (6)
Folder (2)
View (6)

Relationship Types (10)

DisplayName	ID	Source	Target	Accessibility	Abstract
Always On Hight Availability Contains Availability Group	Microsoft.SQLServer.2016.AlwaysOn.AlwaysOnHightAvailabilityContainsAvailabilityGroupGroup	Microsoft.SQLServer.2016.AlwaysOn.AlwaysOnHightAvailability	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupGroup	Public	False
Always On Hight Availability Contains Availability Replica Group	Microsoft.SQLServer.2016.AlwaysOn.AlwaysOnHightAvailabilityContainsAvailabilityReplicaGroup	Microsoft.SQLServer.2016.AlwaysOn.AlwaysOnHightAvailability	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaGroup	Public	False
Always On Hight Availability Contains Availability Database Group	Microsoft.SQLServer.2016.AlwaysOn.AlwaysOnHightAvailabilityContainsDatabaseReplicaGroup	Microsoft.SQLServer.2016.AlwaysOn.AlwaysOnHightAvailability	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaGroup	Public	False
Availability Group contains Availability	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupGroupContainsAvailabilityGroup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupGroup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	Public	False
Availability Replica Group Contains Availability Replica	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaGroupContainsAvailabilityReplica	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaGroup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	Public	False
Database Replica Group Contains Database Replica	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaGroupContainsDatabaseReplica	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaGroup	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	Public	False
Alerts Scope Group L3 Contains Availability Groups Relationship	Microsoft.SQLServer.2016.AlwaysOn.Relationships.AlertsScopeGroupL3ContainsAvailabilityGroups	Microsoft.SQLServer.2016.AlertsScopeGroupL3	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	Internal	False
Microsoft.SQLServer.2016.AlwaysOn.Relationship.AlwaysOnDatabaseReplicas	Microsoft.SQLServer.2016.AlwaysOn.Relationship.AlwaysOnDatabaseReplicas	Microsoft.SQLServer.Generic.Presentation.AlwaysOnDatabaseReplicasGroup	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	Public	False
Microsoft.SQLServer.2016.AlwaysOn.Relationship.AlwaysOnGroups	Microsoft.SQLServer.2016.AlwaysOn.Relationship.AlwaysOnGroups	Microsoft.SQLServer.Generic.Presentation.AlwaysOnAvailabilityGroupsGroup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	Public	False
Microsoft.SQLServer.2016.AlwaysOn.Relationship.AlwaysOnReplicas	Microsoft.SQLServer.2016.AlwaysOn.Relationship.AlwaysOnReplicas	Microsoft.SQLServer.Generic.Presentation.AlwaysOnAvailabilityReplicasGroup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	Public	False

Discoveries (8)

DisplayName	ID	Target	Enabled
MSSQL 2016: SQL Server Always On Database Replicas Discovery	Microsoft.SQLServer.2016.AlwaysOn.AlwaysOnDatabaseReplicasDiscovery	Microsoft.SQLServer.Generic.Presentation.AlwaysOnDatabaseReplicasGroup	True
MSSQL 2016: SQL Server Always On High Availability Group Discovery	Microsoft.SQLServer.2016.AlwaysOn.AlwaysOnGroupOfGroupsDiscovery	Microsoft.SQLServer.2016.AlwaysOn.AlwaysOnHightAvailability	True
MSSQL 2016: SQL Server Always On Groups Discovery	Microsoft.SQLServer.2016.AlwaysOn.AlwaysOnGroupsDiscovery	Microsoft.SQLServer.Generic.Presentation.AlwaysOnAvailabilityGroupsGroup	True
MSSQL 2016: SQL Server Always On Replicas Discovery	Microsoft.SQLServer.2016.AlwaysOn.AlwaysOnReplicasDiscovery	Microsoft.SQLServer.Generic.Presentation.AlwaysOnAvailabilityReplicasGroup	True
MSSQL 2016: Populate SQL Availability Group	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupGroupDiscovery	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupGroup	True
MSSQL 2016: Populate SQL Availability Replica Group	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaGroupDiscovery	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaGroup	True
MSSQL 2016: Populate SQL Database Replica Group	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaGroupDiscovery	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaGroup	True
MSSQL 2016: Alerts Scope Group L3 Discovery	Microsoft.SQLServer.2016.AlwaysOn.Discovery.AlertsScopeGroupL3	Microsoft.SQLServer.2016.AlertsScopeGroupL3	True

Dependency Monitors (24)

DisplayName	ID	Target	Algorithm	Source Monitor	Relationship	Category	Enabled	Alert Generate	Accessibility
Availability Group Availability Rollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupLocalGroupAvailabilityRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupGroup	WorstOf	System.Health.AvailabilityState	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupGroupContainsAvailabilityGroup	AvailabilityHealth	True	False	Internal
Availability Group Configuration Rollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupLocalGroupConfigurationRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupGroup	WorstOf	System.Health.ConfigurationState	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupGroupContainsAvailabilityGroup	ConfigurationHealth	True	False	Internal
Availability Group Rollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupLocalGroupRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupGroup	WorstOf	System.Health.PerformanceState	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupGroupContainsAvailabilityGroup	PerformanceCollection	True	False	Internal
Availability Group Security Rollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupLocalGroupSecurityRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupGroup	WorstOf	System.Health.SecurityState	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupGroupContainsAvailabilityGroup	SecurityHealth	True	False	Internal
Availability Group Availability Rollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupsGroupAvailabilityRollup	Microsoft.SQLServer.Generic.Presentation.AlwaysOnAvailabilityGroupsGroup	WorstOf	System.Health.AvailabilityState	Microsoft.SQLServer.2016.AlwaysOn.Relationship.AlwaysOnGroups	AvailabilityHealth	True	False	Internal
Availability Group Configuration Rollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupsGroupConfigurationRollup	Microsoft.SQLServer.Generic.Presentation.AlwaysOnAvailabilityGroupsGroup	WorstOf	System.Health.ConfigurationState	Microsoft.SQLServer.2016.AlwaysOn.Relationship.AlwaysOnGroups	ConfigurationHealth	True	False	Internal
Availability Group Rollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupsGroupRollup	Microsoft.SQLServer.Generic.Presentation.AlwaysOnAvailabilityGroupsGroup	WorstOf	System.Health.PerformanceState	Microsoft.SQLServer.2016.AlwaysOn.Relationship.AlwaysOnGroups	PerformanceCollection	True	False	Internal
Availability Group Security Rollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupsGroupSecurityRollup	Microsoft.SQLServer.Generic.Presentation.AlwaysOnAvailabilityGroupsGroup	WorstOf	System.Health.SecurityState	Microsoft.SQLServer.2016.AlwaysOn.Relationship.AlwaysOnGroups	SecurityHealth	True	False	Internal
Availability Replica Availability Rollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaLocalGroupAvailabilityRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaGroup	WorstOf	System.Health.AvailabilityState	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaGroupContainsAvailabilityReplica	AvailabilityHealth	True	False	Internal
Availability Replica Configuration Rollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaLocalGroupConfigurationRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaGroup	WorstOf	System.Health.ConfigurationState	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaGroupContainsAvailabilityReplica	ConfigurationHealth	True	False	Internal
Availability Replica Rollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaLocalGroupRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaGroup	WorstOf	System.Health.PerformanceState	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaGroupContainsAvailabilityReplica	PerformanceCollection	True	False	Internal
Availability Replica Security Rollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaLocalGroupSecurityRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaGroup	WorstOf	System.Health.SecurityState	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaGroupContainsAvailabilityReplica	SecurityHealth	True	False	Internal
Availability Replica Availability Rollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicasGroupAvailabilityRollup	Microsoft.SQLServer.Generic.Presentation.AlwaysOnAvailabilityReplicasGroup	WorstOf	System.Health.AvailabilityState	Microsoft.SQLServer.2016.AlwaysOn.Relationship.AlwaysOnReplicas	AvailabilityHealth	True	False	Internal
Availability Replica Configuration Rollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicasGroupConfigurationRollup	Microsoft.SQLServer.Generic.Presentation.AlwaysOnAvailabilityReplicasGroup	WorstOf	System.Health.ConfigurationState	Microsoft.SQLServer.2016.AlwaysOn.Relationship.AlwaysOnReplicas	ConfigurationHealth	True	False	Internal
Availability Replica Rollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicasGroupRollup	Microsoft.SQLServer.Generic.Presentation.AlwaysOnAvailabilityReplicasGroup	WorstOf	System.Health.PerformanceState	Microsoft.SQLServer.2016.AlwaysOn.Relationship.AlwaysOnReplicas	PerformanceCollection	True	False	Internal
Availability Replica Security Rollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicasGroupSecurityRollup	Microsoft.SQLServer.Generic.Presentation.AlwaysOnAvailabilityReplicasGroup	WorstOf	System.Health.SecurityState	Microsoft.SQLServer.2016.AlwaysOn.Relationship.AlwaysOnReplicas	SecurityHealth	True	False	Internal
Database Replica Availability Rollup	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaLocalGroupAvailabilityRollup	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaGroup	WorstOf	System.Health.AvailabilityState	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaGroupContainsDatabaseReplica	AvailabilityHealth	True	False	Internal
Database Replica Configuration Rollup	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaLocalGroupConfigurationRollup	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaGroup	WorstOf	System.Health.ConfigurationState	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaGroupContainsDatabaseReplica	ConfigurationHealth	True	False	Internal
Database Replica Rollup	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaLocalGroupRollup	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaGroup	WorstOf	System.Health.PerformanceState	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaGroupContainsDatabaseReplica	PerformanceCollection	True	False	Internal
Database Replica Security Rollup	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaLocalGroupSecurityRollup	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaGroup	WorstOf	System.Health.SecurityState	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaGroupContainsDatabaseReplica	SecurityHealth	True	False	Internal
Database Replica Availability Rollup	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicasGroupAvailabilityRollup	Microsoft.SQLServer.Generic.Presentation.AlwaysOnDatabaseReplicasGroup	WorstOf	System.Health.AvailabilityState	Microsoft.SQLServer.2016.AlwaysOn.Relationship.AlwaysOnDatabaseReplicas	AvailabilityHealth	True	False	Internal
Database Replica Configuration Rollup	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicasGroupConfigurationRollup	Microsoft.SQLServer.Generic.Presentation.AlwaysOnDatabaseReplicasGroup	WorstOf	System.Health.ConfigurationState	Microsoft.SQLServer.2016.AlwaysOn.Relationship.AlwaysOnDatabaseReplicas	ConfigurationHealth	True	False	Internal
Database Replica Rollup	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicasGroupRollup	Microsoft.SQLServer.Generic.Presentation.AlwaysOnDatabaseReplicasGroup	WorstOf	System.Health.PerformanceState	Microsoft.SQLServer.2016.AlwaysOn.Relationship.AlwaysOnDatabaseReplicas	PerformanceCollection	True	False	Internal
Database Replica Security Rollup	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicasGroupSecurityRollup	Microsoft.SQLServer.Generic.Presentation.AlwaysOnDatabaseReplicasGroup	WorstOf	System.Health.SecurityState	Microsoft.SQLServer.2016.AlwaysOn.Relationship.AlwaysOnDatabaseReplicas	SecurityHealth	True	False	Internal

Folder Items (6)

DisplayName	ID	FolderName	ElementID
Active Alerts	Microsoft.SQLServer.2016.AlwaysOn.ActiveAlertsView	Microfost.SQLServer.2016.AlwaysOn.Folder	Microsoft.SQLServer.2016.AlwaysOn.ActiveAlertsView
Availability Groups	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupStateView	Microfost.SQLServer.2016.AlwaysOn.Folder	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupStateView
Availability Replica Performance	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaPerformanceView	Microsoft.SQLServer.2016.AlwaysOn.PerformanceFolder	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaPerformanceView
Availability Replicas	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaStateView	Microfost.SQLServer.2016.AlwaysOn.Folder	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaStateView
Database Replica Performance	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaPerformanceView	Microsoft.SQLServer.2016.AlwaysOn.PerformanceFolder	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaPerformanceView
Database Replicas	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaStateView	Microfost.SQLServer.2016.AlwaysOn.Folder	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaStateView

Folders (2)

	DisplayName	ID	ParentFolder	Accessibility
	Always On High Availability	Microfost.SQLServer.2016.AlwaysOn.Folder	Microsoft.SQLServer.2016.ViewFolder.Root	Public
	Performance	Microsoft.SQLServer.2016.AlwaysOn.PerformanceFolder	Microfost.SQLServer.2016.AlwaysOn.Folder	Public

Views (6)

DisplayName	ID	Target	Type	Accessibility	Visible
Active Alerts	Microsoft.SQLServer.2016.AlwaysOn.ActiveAlertsView	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	Microsoft.SystemCenter.AlertViewType	Public	True
Availability Groups	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupStateView	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	Microsoft.SystemCenter.StateViewType	Public	True
Availability Replica Performance	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaPerformanceView	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	Microsoft.SystemCenter.PerformanceViewType	Internal	True
Availability Replicas	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaStateView	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	Microsoft.SystemCenter.StateViewType	Public	True
Database Replica Performance	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaPerformanceView	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	Microsoft.SystemCenter.PerformanceViewType	Internal	True
Database Replicas	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaStateView	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	Microsoft.SystemCenter.StateViewType	Public	True