Microsoft SQL Server 2017 on Windows Always On (Views)

Microsoft.SQLServer.2017.AlwaysOn.Windows.Views :: 6.7.60.0 (Management Pack)

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

• Show Management Pack XML
• Get Management Pack data in Excel format
• Download: Microsoft.SQLServer.2017.AlwaysOn.Windows.Views.mp

Management Pack Elements

Classes (2)

	DisplayName	ID	Base Class	Abstract	Hosted	Singleton	Group	Extension	Accessibility
	MSSQL 2017 on Windows Always On: Group of Windows Availability Replicas	Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaGroup	System.Group	False	False	True	True	False	Public
	MSSQL 2017 on Windows Always On: Group of Windows Database Replicas	Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaGroup	System.Group	False	False	True	True	False	Public

Relationship Types (3)

	DisplayName	ID	Source	Target	Accessibility	Abstract
	MSSQL 2017 on Windows Always On: Group of Windows Availability Replicas contains Windows Availability Replica	Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaGroupContainsAvailabilityReplica	Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaGroup	Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica	Internal	False
	MSSQL 2017 on Windows Always On: Group of Windows Availability Replicas Contains Monitoring Pool Alert Collection Relationship	Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaGroupContainsMonitoringPoolAlertCollection	Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaGroup	Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitoringPoolAlertCollection	Internal	False
	MSSQL 2017 on Windows Always On: Group of Windows Database Replicas contains Windows Database Replica	Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaGroupContainsDatabaseReplica	Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaGroup	Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica	Internal	False

Discoveries (2)

	DisplayName	ID	Target	Enabled
	MSSQL 2017 on Windows Always On: Populate Group of Windows Availability Replicas	Microsoft.SQLServer.2017.AlwaysOn.Windows.Discovery.AvailabilityReplicaGroup	Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaGroup	True
	MSSQL 2017 on Windows Always On: Populate Group of Windows Database Replicas	Microsoft.SQLServer.2017.AlwaysOn.Windows.Discovery.DatabaseReplicaGroup	Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaGroup	True

Folder Items (5)

	ID	FolderName	ElementID
	Microsoft.SQLServer.2017.AlwaysOn.Windows.FolderItem.AvailabilityReplica.Performance	Microsoft.SQLServer.2017.AlwaysOn.Windows.Folder.AllPerformance	Microsoft.SQLServer.2017.AlwaysOn.Windows.View.AvailabilityReplica.Performance
	Microsoft.SQLServer.2017.AlwaysOn.Windows.FolderItem.AvailabilityReplica.StateView	Microsoft.SQLServer.2017.AlwaysOn.Windows.Folder.Root	Microsoft.SQLServer.2017.AlwaysOn.Windows.View.AvailabilityReplica.StateView
	Microsoft.SQLServer.2017.AlwaysOn.Windows.FolderItem.DatabaseReplica.Performance	Microsoft.SQLServer.2017.AlwaysOn.Windows.Folder.AllPerformance	Microsoft.SQLServer.2017.AlwaysOn.Windows.View.DatabaseReplica.Performance
	Microsoft.SQLServer.2017.AlwaysOn.Windows.FolderItem.DatabaseReplica.StateView	Microsoft.SQLServer.2017.AlwaysOn.Windows.Folder.Root	Microsoft.SQLServer.2017.AlwaysOn.Windows.View.DatabaseReplica.StateView
	Microsoft.SQLServer.2017.AlwaysOn.Windows.FolderItem.Root.AlertsView	Microsoft.SQLServer.2017.AlwaysOn.Windows.Folder.Root	Microsoft.SQLServer.2017.AlwaysOn.Windows.View.Root.AlertsView

Folders (2)

	DisplayName	ID	ParentFolder	Accessibility
	Performance	Microsoft.SQLServer.2017.AlwaysOn.Windows.Folder.AllPerformance	Microsoft.SQLServer.2017.AlwaysOn.Windows.Folder.Root	Public
	Always On High Availability on Windows	Microsoft.SQLServer.2017.AlwaysOn.Windows.Folder.Root	Microsoft.SQLServer.2017.AlwaysOn.Library.Folder.Root	Public

Views (5)

	DisplayName	ID	Target	Type	Accessibility	Visible
	Availability Replica Performance	Microsoft.SQLServer.2017.AlwaysOn.Windows.View.AvailabilityReplica.Performance	Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica	Microsoft.SystemCenter.PerformanceViewType	Public	True
	Availability Replicas	Microsoft.SQLServer.2017.AlwaysOn.Windows.View.AvailabilityReplica.StateView	Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica	Microsoft.SystemCenter.StateViewType	Public	True
	Database Replica Performance	Microsoft.SQLServer.2017.AlwaysOn.Windows.View.DatabaseReplica.Performance	Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica	Microsoft.SystemCenter.PerformanceViewType	Public	True
	Database Replicas	Microsoft.SQLServer.2017.AlwaysOn.Windows.View.DatabaseReplica.StateView	Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica	Microsoft.SystemCenter.StateViewType	Public	True
	Active Alerts	Microsoft.SQLServer.2017.AlwaysOn.Windows.View.Root.AlertsView	Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaGroup	Microsoft.SystemCenter.AlertViewType	Public	True