Microsoft SQL Server 2016 (Views)

Microsoft.SQLServer.2016.Views :: 7.0.0.0 (Management Pack)

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

Management Pack Elements

Classes (9)

 DisplayNameIDBase ClassAbstractHostedSingletonGroupExtensionAccessibility
Microsoft.SQLServer.2016.AgentsGroupSQL Server 2016 Agents GroupMicrosoft.SQLServer.2016.AgentsGroupSystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2016.AlertsScopeGroupL3MSSQL 2016: Alerts Scope Group L3Microsoft.SQLServer.2016.AlertsScopeGroupL3System.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2016.AlwaysOn.AlwaysOnHightAvailabilityMSSQL 2016: Group of High Availability GroupsMicrosoft.SQLServer.2016.AlwaysOn.AlwaysOnHightAvailabilitySystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupGroupMSSQL 2016: Group of Availability GroupsMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityGroupGroupSystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaGroupMSSQL 2016: Group of Availability ReplicasMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaGroupSystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaGroupMSSQL 2016: Group of Database ReplicasMicrosoft.SQLServer.2016.AlwaysOn.DatabaseReplicaGroupSystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2016.DatabasesGroupSQL Server 2016 Databases GroupMicrosoft.SQLServer.2016.DatabasesGroupSystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2016.InstancesGroupSQL Server 2016 Instance GroupMicrosoft.SQLServer.2016.InstancesGroupSystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2016.MirroringGroupsGroupSQL Server 2016 Mirroring Groups GroupMicrosoft.SQLServer.2016.MirroringGroupsGroupSystem.GroupFalseFalseTrueTrueFalsePublic

Relationship Types (9)

 DisplayNameIDSourceTargetAccessibilityAbstract
Microsoft.SQLServer.2016.AgentsGroupContainsAgentSQL Server 2016 Agents Group Contains AgentMicrosoft.SQLServer.2016.AgentsGroupContainsAgentMicrosoft.SQLServer.2016.AgentsGroupMicrosoft.SQLServer.2016.AgentPublicFalse
Microsoft.SQLServer.2016.DatabasesGroupContainsDatabaseSQL Server 2016 Databases Group Contains DatabaseMicrosoft.SQLServer.2016.DatabasesGroupContainsDatabaseMicrosoft.SQLServer.2016.DatabasesGroupMicrosoft.SQLServer.2016.DatabasePublicFalse
Microsoft.SQLServer.2016.GlobalInstanceGroupContainsDBEngineMSSQL : SQL Server Instance Group Contains InstancesMicrosoft.SQLServer.2016.GlobalInstanceGroupContainsDBEngineMicrosoft.SQLServer.Generic.Presentation.SQLServerInstanceGroupMicrosoft.SQLServer.2016.DBEnginePublicFalse
Microsoft.SQLServer.2016.InstancesGroupContainsDBEngineSQL Server 2016 Instances Group Contains DBEngineMicrosoft.SQLServer.2016.InstancesGroupContainsDBEngineMicrosoft.SQLServer.2016.InstancesGroupMicrosoft.SQLServer.2016.DBEnginePublicFalse
Microsoft.SQLServer.2016.Relationships.AlertsScopeGroupContainsAlertsScopeGroupL3Alerts Scope Group Contains Alerts Scope Group L3 RelationshipMicrosoft.SQLServer.2016.Relationships.AlertsScopeGroupContainsAlertsScopeGroupL3Microsoft.SQLServer.Generic.Presentation.SQLServerAlertsScopeGroupMicrosoft.SQLServer.2016.AlertsScopeGroupL3InternalFalse
Microsoft.SQLServer.2016.Relationships.AlertsScopeGroupContainsSeedAlerts Scope Group Contains Seed RelationshipMicrosoft.SQLServer.2016.Relationships.AlertsScopeGroupContainsSeedMicrosoft.SQLServer.Generic.Presentation.SQLServerAlertsScopeGroupMicrosoft.SQLServer.2016.SeedInternalFalse
Microsoft.SQLServer.2016.Relationships.AlertsScopeGroupL3ContainsEventLogCollectionTargetAlerts Scope Group L3 Contains Event Log Collection Target RelationshipMicrosoft.SQLServer.2016.Relationships.AlertsScopeGroupL3ContainsEventLogCollectionTargetMicrosoft.SQLServer.2016.AlertsScopeGroupL3Microsoft.SQLServer.2016.EventLogCollectionTargetInternalFalse
Microsoft.SQLServer.2016.Relationships.AlertsScopeGroupL3ContainsServiceRolesAlertsScopeGroupL3ContainsServiceRole RelationshipMicrosoft.SQLServer.2016.Relationships.AlertsScopeGroupL3ContainsServiceRolesMicrosoft.SQLServer.2016.AlertsScopeGroupL3Microsoft.SQLServer.2016.ServerRoleInternalFalse
Microsoft.SQLServer.2016.Relationships.ServerRolesGroupContainsServerRolesServer Roles Group Contains Server Roles RelationshipMicrosoft.SQLServer.2016.Relationships.ServerRolesGroupContainsServerRolesMicrosoft.SQLServer.Generic.Presentation.ServerRolesGroupMicrosoft.SQLServer.2016.ServerRoleInternalFalse

Discoveries (8)

 DisplayNameIDTargetEnabled
Microsoft.SQLServer.2016.AgentsGroup.DiscoveryMSSQL 2016: Populate SQL Server 2016 Agents GroupMicrosoft.SQLServer.2016.AgentsGroup.DiscoveryMicrosoft.SQLServer.2016.AgentsGroupTrue
Microsoft.SQLServer.2016.AlertsScopeGroupDiscoveryMSSQL 2016: Alerts Scope Group DiscoveryMicrosoft.SQLServer.2016.AlertsScopeGroupDiscoveryMicrosoft.SQLServer.Generic.Presentation.SQLServerAlertsScopeGroupTrue
Microsoft.SQLServer.2016.DatabasesGroup.DiscoveryMSSQL 2016: Populate SQL Server 2016 Databases GroupMicrosoft.SQLServer.2016.DatabasesGroup.DiscoveryMicrosoft.SQLServer.2016.DatabasesGroupTrue
Microsoft.SQLServer.2016.Discovery.AlertsScopeGroupL3MSSQL 2016: Alerts Scope Group L3 DiscoveryMicrosoft.SQLServer.2016.Discovery.AlertsScopeGroupL3Microsoft.SQLServer.2016.AlertsScopeGroupL3True
Microsoft.SQLServer.2016.GenericComputerGroupDiscoveryMSSQL 2016: Discover SQL Server Computer Group membershipMicrosoft.SQLServer.2016.GenericComputerGroupDiscoveryMicrosoft.SQLServer.Generic.Presentation.ComputersGroupTrue
Microsoft.SQLServer.2016.GlobalInstanceGroupDiscoveryMSSQL: Populate SQL Server Instance GroupMicrosoft.SQLServer.2016.GlobalInstanceGroupDiscoveryMicrosoft.SQLServer.Generic.Presentation.SQLServerInstanceGroupTrue
Microsoft.SQLServer.2016.InstancesGroup.DiscoveryMSSQL 2016: Populate SQL Server 2016 Instance GroupMicrosoft.SQLServer.2016.InstancesGroup.DiscoveryMicrosoft.SQLServer.2016.InstancesGroupTrue
Microsoft.SQLServer.2016.ServerRolesGroupDiscoveryMSSQL 2016: Server Roles Group DiscoveryMicrosoft.SQLServer.2016.ServerRolesGroupDiscoveryMicrosoft.SQLServer.Generic.Presentation.ServerRolesGroupTrue

Folder Items (20)

 DisplayNameIDFolderNameElementID
Microsoft.SQLServer.2016.Agent.AlertsViewActive AlertsMicrosoft.SQLServer.2016.Agent.AlertsViewMicrosoft.SQLServer.2016.ViewFolder.AgentMicrosoft.SQLServer.2016.Agent.AlertsView
Microsoft.SQLServer.2016.Agent.StateViewSQL AgentsMicrosoft.SQLServer.2016.Agent.StateViewMicrosoft.SQLServer.2016.ViewFolder.AgentMicrosoft.SQLServer.2016.Agent.StateView
Microsoft.SQLServer.2016.AgentJob.StateViewSQL Agent JobsMicrosoft.SQLServer.2016.AgentJob.StateViewMicrosoft.SQLServer.2016.ViewFolder.AgentMicrosoft.SQLServer.2016.AgentJob.StateView
Microsoft.SQLServer.2016.Database.AlertsViewActive AlertsMicrosoft.SQLServer.2016.Database.AlertsViewMicrosoft.SQLServer.2016.ViewFolder.DatabasesMicrosoft.SQLServer.2016.Database.AlertsView
Microsoft.SQLServer.2016.Database.AllPerformanceDataViewAll Performance DataMicrosoft.SQLServer.2016.Database.AllPerformanceDataViewMicrosoft.SQLServer.2016.ViewFolder.DatabasesMicrosoft.SQLServer.2016.Database.AllPerformanceDataView
Microsoft.SQLServer.2016.Database.StateViewDatabasesMicrosoft.SQLServer.2016.Database.StateViewMicrosoft.SQLServer.2016.ViewFolder.DatabasesMicrosoft.SQLServer.2016.Database.StateView
Microsoft.SQLServer.2016.DBEngine.AlertsViewActive AlertsMicrosoft.SQLServer.2016.DBEngine.AlertsViewMicrosoft.SQLServer.2016.ViewFolder.DBEnginesMicrosoft.SQLServer.2016.DBEngine.AlertsView
Microsoft.SQLServer.2016.DBEngine.AllPerformanceDataViewAll Performance DataMicrosoft.SQLServer.2016.DBEngine.AllPerformanceDataViewMicrosoft.SQLServer.2016.ViewFolder.DBEnginesMicrosoft.SQLServer.2016.DBEngine.AllPerformanceDataView
Microsoft.SQLServer.2016.DBEngine.ResourcePoolsViewResource PoolsMicrosoft.SQLServer.2016.DBEngine.ResourcePoolsViewMicrosoft.SQLServer.2016.ViewFolder.DBEnginesMicrosoft.SQLServer.2016.DBEngine.ResourcePoolsView
Microsoft.SQLServer.2016.DBEngine.StateViewDatabase EnginesMicrosoft.SQLServer.2016.DBEngine.StateViewMicrosoft.SQLServer.2016.ViewFolder.DBEnginesMicrosoft.SQLServer.2016.DBEngine.StateView
Microsoft.SQLServer.2016.DBFileGroup.StateViewFilegroupsMicrosoft.SQLServer.2016.DBFileGroup.StateViewMicrosoft.SQLServer.2016.ViewFolder.DatabasesMicrosoft.SQLServer.2016.DBFileGroup.StateView
Microsoft.SQLServer.2016.Server.StateViewComputersMicrosoft.SQLServer.2016.Server.StateViewMicrosoft.SQLServer.2016.ViewFolder.RootMicrosoft.SQLServer.2016.Server.StateView
Microsoft.SQLServer.2016.ServerRole.ActiveAlertsViewActive AlertsMicrosoft.SQLServer.2016.ServerRole.ActiveAlertsViewMicrosoft.SQLServer.2016.ViewFolder.RootMicrosoft.SQLServer.2016.ServerRole.ActiveAlertsView
Microsoft.SQLServer.2016.ServerRole.AllPerformanceDataViewAll Performance DataMicrosoft.SQLServer.2016.ServerRole.AllPerformanceDataViewMicrosoft.SQLServer.2016.ViewFolder.RootMicrosoft.SQLServer.2016.ServerRole.AllPerformanceDataView
Microsoft.SQLServer.2016.ServerRole.TaskStatusViewTask StatusMicrosoft.SQLServer.2016.ServerRole.TaskStatusViewMicrosoft.SQLServer.2016.ViewFolder.RootMicrosoft.SQLServer.2016.ServerRole.TaskStatusView
Microsoft.SQLServer.2016.View.Container.StateMemory-Optimized Data Filegroup ContainersMicrosoft.SQLServer.2016.View.Container.StateMicrosoft.SQLServer.2016.ViewFolder.InMemoryOLTPMicrosoft.SQLServer.2016.View.Container.State
Microsoft.SQLServer.2016.View.DBFileGroupFx.StateMemory-Optimized Data FilegroupsMicrosoft.SQLServer.2016.View.DBFileGroupFx.StateMicrosoft.SQLServer.2016.ViewFolder.InMemoryOLTPMicrosoft.SQLServer.2016.View.DBFileGroupFx.State
Microsoft.SQLServer.2016.View.InMemoryOLTP.AlertsActive AlertsMicrosoft.SQLServer.2016.View.InMemoryOLTP.AlertsMicrosoft.SQLServer.2016.ViewFolder.InMemoryOLTPMicrosoft.SQLServer.2016.View.InMemoryOLTP.Alerts
Microsoft.SQLServer.2016.View.InMemoryOLTP.AllPerformanceDataAll Performance DataMicrosoft.SQLServer.2016.View.InMemoryOLTP.AllPerformanceDataMicrosoft.SQLServer.2016.ViewFolder.InMemoryOLTPMicrosoft.SQLServer.2016.View.InMemoryOLTP.AllPerformanceData
Microsoft.SQLServer.2016.View.UserResourcePool.StateResource PoolsMicrosoft.SQLServer.2016.View.UserResourcePool.StateMicrosoft.SQLServer.2016.ViewFolder.InMemoryOLTPMicrosoft.SQLServer.2016.View.UserResourcePool.State

Folders (5)

 DisplayNameIDParentFolderAccessibility
Microsoft.SQLServer.2016.ViewFolder.AgentSQL AgentMicrosoft.SQLServer.2016.ViewFolder.AgentMicrosoft.SQLServer.2016.ViewFolder.RootPublic
Microsoft.SQLServer.2016.ViewFolder.DatabasesDatabasesMicrosoft.SQLServer.2016.ViewFolder.DatabasesMicrosoft.SQLServer.2016.ViewFolder.RootPublic
Microsoft.SQLServer.2016.ViewFolder.DBEnginesDatabase EnginesMicrosoft.SQLServer.2016.ViewFolder.DBEnginesMicrosoft.SQLServer.2016.ViewFolder.RootPublic
Microsoft.SQLServer.2016.ViewFolder.InMemoryOLTPMemory-Optimized DataMicrosoft.SQLServer.2016.ViewFolder.InMemoryOLTPMicrosoft.SQLServer.2016.ViewFolder.DatabasesPublic
Microsoft.SQLServer.2016.ViewFolder.RootSQL Server 2016Microsoft.SQLServer.2016.ViewFolder.RootMicrosoft.SQLServer.Generic.Presentation.Folder.DatabaseEnginePublic

Views (23)

 DisplayNameIDTargetTypeAccessibilityVisible
Microsoft.SQLServer.2016.Agent.AlertsViewActive AlertsMicrosoft.SQLServer.2016.Agent.AlertsViewMicrosoft.SQLServer.2016.AgentMicrosoft.SystemCenter.AlertViewTypePublicTrue
Microsoft.SQLServer.2016.Agent.StateViewSQL AgentsMicrosoft.SQLServer.2016.Agent.StateViewMicrosoft.SQLServer.2016.AgentMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2016.AgentJob.StateViewSQL Agent JobsMicrosoft.SQLServer.2016.AgentJob.StateViewMicrosoft.SQLServer.2016.AgentJobMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2016.Database.AlertsViewActive AlertsMicrosoft.SQLServer.2016.Database.AlertsViewMicrosoft.SQLServer.2016.DatabaseMicrosoft.SystemCenter.AlertViewTypePublicTrue
Microsoft.SQLServer.2016.Database.AllPerformanceDataViewAll Performance DataMicrosoft.SQLServer.2016.Database.AllPerformanceDataViewMicrosoft.SQLServer.2016.DatabaseMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.2016.Database.DBSizePerformanceDataViewDatabase Free SpaceMicrosoft.SQLServer.2016.Database.DBSizePerformanceDataViewMicrosoft.SQLServer.2016.DatabaseMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.2016.Database.LogSizePerformanceDataViewTransaction Log Free SpaceMicrosoft.SQLServer.2016.Database.LogSizePerformanceDataViewMicrosoft.SQLServer.2016.DatabaseMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.2016.Database.StateViewDatabasesMicrosoft.SQLServer.2016.Database.StateViewMicrosoft.SQLServer.2016.DatabaseMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2016.DBEngine.AlertsViewActive AlertsMicrosoft.SQLServer.2016.DBEngine.AlertsViewMicrosoft.SQLServer.2016.DBEngineMicrosoft.SystemCenter.AlertViewTypePublicTrue
Microsoft.SQLServer.2016.DBEngine.AllPerformanceDataViewAll Performance DataMicrosoft.SQLServer.2016.DBEngine.AllPerformanceDataViewMicrosoft.SQLServer.2016.DBEngineMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.2016.DBEngine.ResourcePoolsViewResource PoolsMicrosoft.SQLServer.2016.DBEngine.ResourcePoolsViewMicrosoft.SQLServer.2016.ResourcePoolMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2016.DBEngine.StateViewDatabase EnginesMicrosoft.SQLServer.2016.DBEngine.StateViewMicrosoft.SQLServer.2016.DBEngineMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2016.DBEngine.UserConnectionsViewUser ConnectionsMicrosoft.SQLServer.2016.DBEngine.UserConnectionsViewMicrosoft.SQLServer.2016.DBEngineMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.2016.DBFileGroup.StateViewFilegroupsMicrosoft.SQLServer.2016.DBFileGroup.StateViewMicrosoft.SQLServer.2016.FileGroupMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2016.Server.StateViewComputersMicrosoft.SQLServer.2016.Server.StateViewMicrosoft.Windows.ComputerMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2016.ServerRole.ActiveAlertsViewActive AlertsMicrosoft.SQLServer.2016.ServerRole.ActiveAlertsViewMicrosoft.SQLServer.2016.AlertsScopeGroupL3Microsoft.SystemCenter.AlertViewTypePublicTrue
Microsoft.SQLServer.2016.ServerRole.AllPerformanceDataViewAll Performance DataMicrosoft.SQLServer.2016.ServerRole.AllPerformanceDataViewMicrosoft.SQLServer.2016.ServerRoleMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.2016.ServerRole.TaskStatusViewTask StatusMicrosoft.SQLServer.2016.ServerRole.TaskStatusViewMicrosoft.SQLServer.2016.ServerRoleMicrosoft.SystemCenter.TaskStatusViewTypePublicTrue
Microsoft.SQLServer.2016.View.Container.StateMemory-Optimized Data Filegroup ContainersMicrosoft.SQLServer.2016.View.Container.StateMicrosoft.SQLServer.2016.ContainerMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2016.View.DBFileGroupFx.StateMemory-Optimized Data FilegroupsMicrosoft.SQLServer.2016.View.DBFileGroupFx.StateMicrosoft.SQLServer.2016.DBFileGroupFxMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2016.View.InMemoryOLTP.AlertsActive AlertsMicrosoft.SQLServer.2016.View.InMemoryOLTP.AlertsMicrosoft.SQLServer.2016.InMemoryOLTPScopeGroupMicrosoft.SystemCenter.AlertViewTypePublicTrue
Microsoft.SQLServer.2016.View.InMemoryOLTP.AllPerformanceDataAll Performance DataMicrosoft.SQLServer.2016.View.InMemoryOLTP.AllPerformanceDataMicrosoft.SQLServer.2016.InMemoryOLTPScopeGroupMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.2016.View.UserResourcePool.StateResource PoolsMicrosoft.SQLServer.2016.View.UserResourcePool.StateMicrosoft.SQLServer.2016.ResourcePoolMicrosoft.SystemCenter.StateViewTypePublicTrue