Microsoft SQL Server 2017+ on Linux (Views)

Microsoft.SQLServer.Linux.Views :: 7.0.7.0 (Management Pack)

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

Summary

Microsoft SQL Server 2017+ on Linux (Views) Management Pack contains views and folder structure for Microsoft SQL Server 2017+ on Linux management packs. This Management Pack depends on Microsoft SQL Server 2017+ on Linux (Discovery) Management Pack and Microsoft SQL Server Core Library (Views) Management Pack.

Management Pack Elements

Classes (6)

 DisplayNameIDBase ClassAbstractHostedSingletonGroupExtensionAccessibility
Microsoft.SQLServer.Linux.AllSQLServerObjectsGroupMSSQL on Linux: All SQL Server Objects GroupMicrosoft.SQLServer.Linux.AllSQLServerObjectsGroupSystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.Linux.AvailabilityReplicaGroupMSSQL on Linux: Group of Linux Availability ReplicasMicrosoft.SQLServer.Linux.AvailabilityReplicaGroupSystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.Linux.DatabaseReplicaGroupMSSQL on Linux: Group of Linux Database ReplicasMicrosoft.SQLServer.Linux.DatabaseReplicaGroupSystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.Linux.FilegroupsGroupMSSQL on Linux: All SQL Server Filegroups GroupMicrosoft.SQLServer.Linux.FilegroupsGroupSystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.Linux.InMemoryOLTPResourcePoolGroupMSSQL on Linux: Memory-Optimized Data Resource Pool GroupMicrosoft.SQLServer.Linux.InMemoryOLTPResourcePoolGroupSystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.Linux.InMemoryOLTPScopeGroupMSSQL on Linux: Memory-Optimized Data Scope GroupMicrosoft.SQLServer.Linux.InMemoryOLTPScopeGroupSystem.GroupFalseFalseTrueTrueFalsePublic

Relationship Types (12)

 DisplayNameIDSourceTargetAccessibilityAbstract
Microsoft.SQLServer.Linux.AllSQLServerObjectsGroupContainsAgentMSSQL on Linux: All SQL Server Objects Group сontains SQL Server Agent RelationshipMicrosoft.SQLServer.Linux.AllSQLServerObjectsGroupContainsAgentMicrosoft.SQLServer.Linux.AllSQLServerObjectsGroupMicrosoft.SQLServer.Linux.AgentInternalFalse
Microsoft.SQLServer.Linux.AllSQLServerObjectsGroupContainsDBEngineMSSQL on Linux: All SQL Server Objects Group сontains SQL Server DB Engine RelationshipMicrosoft.SQLServer.Linux.AllSQLServerObjectsGroupContainsDBEngineMicrosoft.SQLServer.Linux.AllSQLServerObjectsGroupMicrosoft.SQLServer.Linux.DBEngineInternalFalse
Microsoft.SQLServer.Linux.AllSQLServerObjectsGroupContainsMonitoringPoolAlertCollectionMSSQL on Linux: All SQL Server objects Group сontains SQL Server Monitoring Pool Alert Collection RelationshipMicrosoft.SQLServer.Linux.AllSQLServerObjectsGroupContainsMonitoringPoolAlertCollectionMicrosoft.SQLServer.Linux.AllSQLServerObjectsGroupMicrosoft.SQLServer.Linux.MonitoringPoolAlertCollectionInternalFalse
Microsoft.SQLServer.Linux.AvailabilityReplicaGroupContainsAvailabilityReplicaMSSQL on Linux: Group of Linux Availability Replicas contains Linux Availability ReplicaMicrosoft.SQLServer.Linux.AvailabilityReplicaGroupContainsAvailabilityReplicaMicrosoft.SQLServer.Linux.AvailabilityReplicaGroupMicrosoft.SQLServer.Linux.AvailabilityReplicaInternalFalse
Microsoft.SQLServer.Linux.AvailabilityReplicaGroupContainsMonitoringPoolAlertCollectionMSSQL on Linux: Group of Linux Availability Replicas Contains Monitoring Pool Alert Collection RelationshipMicrosoft.SQLServer.Linux.AvailabilityReplicaGroupContainsMonitoringPoolAlertCollectionMicrosoft.SQLServer.Linux.AvailabilityReplicaGroupMicrosoft.SQLServer.Linux.MonitoringPoolAlertCollectionInternalFalse
Microsoft.SQLServer.Linux.DatabaseReplicaGroupContainsDatabaseReplicaMSSQL on Linux: Group of Linux Database Replicas contains Linux Database ReplicaMicrosoft.SQLServer.Linux.DatabaseReplicaGroupContainsDatabaseReplicaMicrosoft.SQLServer.Linux.DatabaseReplicaGroupMicrosoft.SQLServer.Linux.DatabaseReplicaInternalFalse
Microsoft.SQLServer.Linux.FilegroupsGroupContainsDBFilegroupMSSQL on Linux: All SQL Server Filegroups Group сontains DB Filegroup RelationshipMicrosoft.SQLServer.Linux.FilegroupsGroupContainsDBFilegroupMicrosoft.SQLServer.Linux.FilegroupsGroupMicrosoft.SQLServer.Linux.DBFilegroupInternalFalse
Microsoft.SQLServer.Linux.FilegroupsGroupContainsDBFilegroupFdMSSQL on Linux: All SQL Server Filegroups Group сontains DB FILESTREAM Filegroup RelationshipMicrosoft.SQLServer.Linux.FilegroupsGroupContainsDBFilegroupFdMicrosoft.SQLServer.Linux.FilegroupsGroupMicrosoft.SQLServer.Linux.DBFilegroupFdInternalFalse
Microsoft.SQLServer.Linux.FilegroupsGroupContainsDBFilegroupFxMSSQL on Linux: All SQL Server Filegroups Group сontains DB Memory-Optimized Data Filegroup RelationshipMicrosoft.SQLServer.Linux.FilegroupsGroupContainsDBFilegroupFxMicrosoft.SQLServer.Linux.FilegroupsGroupMicrosoft.SQLServer.Linux.DBFilegroupFxInternalFalse
Microsoft.SQLServer.Linux.InMemoryOLTPResourcePoolGroupContainsResourcePoolMSSQL on Linux: SQL Server Memory-Optimized Data Resource Pool Group contains SQL Server Resource Pool on Linux RelationshipMicrosoft.SQLServer.Linux.InMemoryOLTPResourcePoolGroupContainsResourcePoolMicrosoft.SQLServer.Linux.InMemoryOLTPResourcePoolGroupMicrosoft.SQLServer.Linux.ResourcePoolInternalFalse
Microsoft.SQLServer.Linux.InMemoryOLTPScopeGroupContainsDBFilegroupFxMSSQL on Linux: SQL Server Memory-Optimized Data Scope Group contains SQL Server DB Memory-Optimized Data Filegroup RelationshipMicrosoft.SQLServer.Linux.InMemoryOLTPScopeGroupContainsDBFilegroupFxMicrosoft.SQLServer.Linux.InMemoryOLTPScopeGroupMicrosoft.SQLServer.Linux.DBFilegroupFxInternalFalse
Microsoft.SQLServer.Linux.InMemoryOLTPScopeGroupContainsInMemoryOLTPResourcePoolGroupMSSQL on Linux: SQL Server Memory-Optimized Data Scope Group contains SQL Server Memory-Optimized Data Resource Pool Group RelationshipMicrosoft.SQLServer.Linux.InMemoryOLTPScopeGroupContainsInMemoryOLTPResourcePoolGroupMicrosoft.SQLServer.Linux.InMemoryOLTPScopeGroupMicrosoft.SQLServer.Linux.InMemoryOLTPResourcePoolGroupInternalFalse

Discoveries (6)

 DisplayNameIDTargetEnabled
Microsoft.SQLServer.Linux.Discovery.AllSQLServerObjectsGroupMSSQL on Linux: All SQL Server Objects Group DiscoveryMicrosoft.SQLServer.Linux.Discovery.AllSQLServerObjectsGroupMicrosoft.SQLServer.Linux.AllSQLServerObjectsGroupTrue
Microsoft.SQLServer.Linux.Discovery.AvailabilityReplicaGroupMSSQL on Linux: Populate Group of Linux Availability ReplicasMicrosoft.SQLServer.Linux.Discovery.AvailabilityReplicaGroupMicrosoft.SQLServer.Linux.AvailabilityReplicaGroupTrue
Microsoft.SQLServer.Linux.Discovery.DatabaseReplicaGroupMSSQL on Linux: Populate Group of Linux Database ReplicasMicrosoft.SQLServer.Linux.Discovery.DatabaseReplicaGroupMicrosoft.SQLServer.Linux.DatabaseReplicaGroupTrue
Microsoft.SQLServer.Linux.Discovery.FilegroupsGroupMSSQL on Linux: All SQL Server Filegroups Group DiscoveryMicrosoft.SQLServer.Linux.Discovery.FilegroupsGroupMicrosoft.SQLServer.Linux.FilegroupsGroupTrue
Microsoft.SQLServer.Linux.Discovery.InMemoryOLTPResourcePoolGroupMSSQL on Linux: SQL Server Memory-Optimized Data Resource Pool Group DiscoveryMicrosoft.SQLServer.Linux.Discovery.InMemoryOLTPResourcePoolGroupMicrosoft.SQLServer.Linux.InMemoryOLTPResourcePoolGroupTrue
Microsoft.SQLServer.Linux.Discovery.InMemoryOLTPScopeGroupMSSQL on Linux: Memory-Optimized Data Scope Group DiscoveryMicrosoft.SQLServer.Linux.Discovery.InMemoryOLTPScopeGroupMicrosoft.SQLServer.Linux.InMemoryOLTPScopeGroupTrue

Folder Items (15)

 IDFolderNameElementID
Microsoft.SQLServer.Linux.FolderItem.Agent.AlertsViewMicrosoft.SQLServer.Linux.FolderItem.Agent.AlertsViewMicrosoft.SQLServer.Linux.Folder.AgentMicrosoft.SQLServer.Linux.View.Agent.AlertsView
Microsoft.SQLServer.Linux.FolderItem.Agent.StateViewMicrosoft.SQLServer.Linux.FolderItem.Agent.StateViewMicrosoft.SQLServer.Linux.Folder.AgentMicrosoft.SQLServer.Linux.View.Agent.StateView
Microsoft.SQLServer.Linux.FolderItem.AgentJob.StateViewMicrosoft.SQLServer.Linux.FolderItem.AgentJob.StateViewMicrosoft.SQLServer.Linux.Folder.AgentMicrosoft.SQLServer.Linux.View.AgentJob.StateView
Microsoft.SQLServer.Linux.FolderItem.AvailabilityReplica.PerformanceMicrosoft.SQLServer.Linux.FolderItem.AvailabilityReplica.PerformanceMicrosoft.SQLServer.Linux.Folder.AllPerformanceAlwaysOnMicrosoft.SQLServer.Linux.View.AvailabilityReplica.Performance
Microsoft.SQLServer.Linux.FolderItem.AvailabilityReplica.StateViewMicrosoft.SQLServer.Linux.FolderItem.AvailabilityReplica.StateViewMicrosoft.SQLServer.Linux.Folder.RootAlwaysOnMicrosoft.SQLServer.Linux.View.AvailabilityReplica.StateView
Microsoft.SQLServer.Linux.FolderItem.Container.StateViewMicrosoft.SQLServer.Linux.FolderItem.Container.StateViewMicrosoft.SQLServer.Linux.Folder.InMemoryOLTPMicrosoft.SQLServer.Linux.View.Container.StateView
Microsoft.SQLServer.Linux.FolderItem.Database.StateViewMicrosoft.SQLServer.Linux.FolderItem.Database.StateViewMicrosoft.SQLServer.Linux.Folder.DBEngineMicrosoft.SQLServer.Linux.View.Filegroup.StateView
Microsoft.SQLServer.Linux.FolderItem.DatabaseReplica.PerformanceMicrosoft.SQLServer.Linux.FolderItem.DatabaseReplica.PerformanceMicrosoft.SQLServer.Linux.Folder.AllPerformanceAlwaysOnMicrosoft.SQLServer.Linux.View.DatabaseReplica.Performance
Microsoft.SQLServer.Linux.FolderItem.DatabaseReplica.StateViewMicrosoft.SQLServer.Linux.FolderItem.DatabaseReplica.StateViewMicrosoft.SQLServer.Linux.Folder.RootAlwaysOnMicrosoft.SQLServer.Linux.View.DatabaseReplica.StateView
Microsoft.SQLServer.Linux.FolderItem.DBEngine.StateViewMicrosoft.SQLServer.Linux.FolderItem.DBEngine.StateViewMicrosoft.SQLServer.Linux.Folder.DBEngineMicrosoft.SQLServer.Linux.View.DBEngine.StateView
Microsoft.SQLServer.Linux.FolderItem.DBFilegroupFx.StateViewMicrosoft.SQLServer.Linux.FolderItem.DBFilegroupFx.StateViewMicrosoft.SQLServer.Linux.Folder.InMemoryOLTPMicrosoft.SQLServer.Linux.View.DBFilegroupFx.StateView
Microsoft.SQLServer.Linux.FolderItem.InMemoryOLTP.AlertsViewMicrosoft.SQLServer.Linux.FolderItem.InMemoryOLTP.AlertsViewMicrosoft.SQLServer.Linux.Folder.InMemoryOLTPMicrosoft.SQLServer.Linux.View.InMemoryOLTP.AlertsView
Microsoft.SQLServer.Linux.FolderItem.InMemoryOLTP.AllPerformanceMicrosoft.SQLServer.Linux.FolderItem.InMemoryOLTP.AllPerformanceMicrosoft.SQLServer.Linux.Folder.InMemoryOLTPMicrosoft.SQLServer.Linux.View.InMemoryOLTP.AllPerformance
Microsoft.SQLServer.Linux.FolderItem.InMemoryOLTPResourcePool.StateViewMicrosoft.SQLServer.Linux.FolderItem.InMemoryOLTPResourcePool.StateViewMicrosoft.SQLServer.Linux.Folder.InMemoryOLTPMicrosoft.SQLServer.Linux.View.InMemoryOLTPResourcePool.StateView
Microsoft.SQLServer.Linux.FolderItem.RootAlwaysOn.AlertsViewMicrosoft.SQLServer.Linux.FolderItem.RootAlwaysOn.AlertsViewMicrosoft.SQLServer.Linux.Folder.RootAlwaysOnMicrosoft.SQLServer.Linux.View.RootAlwaysOn.AlertsView

Folders (5)

 DisplayNameIDParentFolderAccessibility
Microsoft.SQLServer.Linux.Folder.AgentSQL Agent on LinuxMicrosoft.SQLServer.Linux.Folder.AgentMicrosoft.SQLServer.Core.Folder.AgentPublic
Microsoft.SQLServer.Linux.Folder.AllPerformanceAlwaysOnPerformanceMicrosoft.SQLServer.Linux.Folder.AllPerformanceAlwaysOnMicrosoft.SQLServer.Linux.Folder.RootAlwaysOnPublic
Microsoft.SQLServer.Linux.Folder.DBEngineDatabase Engines on LinuxMicrosoft.SQLServer.Linux.Folder.DBEngineMicrosoft.SQLServer.Core.Folder.DBEnginePublic
Microsoft.SQLServer.Linux.Folder.InMemoryOLTPMemory-Optimized Data on LinuxMicrosoft.SQLServer.Linux.Folder.InMemoryOLTPMicrosoft.SQLServer.Core.Folder.InMemoryOLTPPublic
Microsoft.SQLServer.Linux.Folder.RootAlwaysOnAlways On High Availability on LinuxMicrosoft.SQLServer.Linux.Folder.RootAlwaysOnMicrosoft.SQLServer.Core.Folder.RootAlwaysOnPublic

Views (16)

 DisplayNameIDTargetTypeAccessibilityVisible
Microsoft.SQLServer.Linux.View.Agent.AlertsViewActive AlertsMicrosoft.SQLServer.Linux.View.Agent.AlertsViewMicrosoft.SQLServer.Linux.AgentMicrosoft.SystemCenter.AlertViewTypePublicTrue
Microsoft.SQLServer.Linux.View.Agent.StateViewSQL AgentsMicrosoft.SQLServer.Linux.View.Agent.StateViewMicrosoft.SQLServer.Linux.AgentMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.Linux.View.AgentJob.StateViewSQL Agent JobsMicrosoft.SQLServer.Linux.View.AgentJob.StateViewMicrosoft.SQLServer.Linux.AgentJobMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.Linux.View.AvailabilityReplica.PerformanceAvailability Replica PerformanceMicrosoft.SQLServer.Linux.View.AvailabilityReplica.PerformanceMicrosoft.SQLServer.Linux.AvailabilityReplicaMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.Linux.View.AvailabilityReplica.StateViewAvailability ReplicasMicrosoft.SQLServer.Linux.View.AvailabilityReplica.StateViewMicrosoft.SQLServer.Linux.AvailabilityReplicaMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.Linux.View.Container.StateViewMemory-Optimized Data Filegroup ContainersMicrosoft.SQLServer.Linux.View.Container.StateViewMicrosoft.SQLServer.Linux.ContainerMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.Linux.View.Database.StateViewDatabasesMicrosoft.SQLServer.Linux.View.Database.StateViewMicrosoft.SQLServer.Linux.DatabaseMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.Linux.View.DatabaseReplica.PerformanceDatabase Replica PerformanceMicrosoft.SQLServer.Linux.View.DatabaseReplica.PerformanceMicrosoft.SQLServer.Linux.DatabaseReplicaMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.Linux.View.DatabaseReplica.StateViewDatabase ReplicasMicrosoft.SQLServer.Linux.View.DatabaseReplica.StateViewMicrosoft.SQLServer.Linux.DatabaseReplicaMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.Linux.View.DBEngine.StateViewDatabase EnginesMicrosoft.SQLServer.Linux.View.DBEngine.StateViewMicrosoft.SQLServer.Linux.DBEngineMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.Linux.View.DBFilegroupFx.StateViewMemory-Optimized Data FilegroupsMicrosoft.SQLServer.Linux.View.DBFilegroupFx.StateViewMicrosoft.SQLServer.Linux.DBFilegroupFxMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.Linux.View.Filegroup.StateViewFilegroupsMicrosoft.SQLServer.Linux.View.Filegroup.StateViewMicrosoft.SQLServer.Core.FilegroupMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.Linux.View.InMemoryOLTP.AlertsViewActive AlertsMicrosoft.SQLServer.Linux.View.InMemoryOLTP.AlertsViewMicrosoft.SQLServer.Linux.InMemoryOLTPScopeGroupMicrosoft.SystemCenter.AlertViewTypePublicTrue
Microsoft.SQLServer.Linux.View.InMemoryOLTP.AllPerformanceAll Performance DataMicrosoft.SQLServer.Linux.View.InMemoryOLTP.AllPerformanceMicrosoft.SQLServer.Linux.InMemoryOLTPScopeGroupMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.Linux.View.InMemoryOLTPResourcePool.StateViewResource PoolsMicrosoft.SQLServer.Linux.View.InMemoryOLTPResourcePool.StateViewMicrosoft.SQLServer.Linux.ResourcePoolMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.Linux.View.RootAlwaysOn.AlertsViewActive AlertsMicrosoft.SQLServer.Linux.View.RootAlwaysOn.AlertsViewMicrosoft.SQLServer.Linux.AvailabilityReplicaGroupMicrosoft.SystemCenter.AlertViewTypePublicTrue

Component Implementations (1)

 IDTypePlatformTargetAccessibility
Microsoft.SQLServer.Linux.Dashboards.SummaryImplementationMicrosoft.SQLServer.Linux.Dashboards.SummaryImplementationMicrosoft.SQLServer.Linux.Dashboards.SummaryWpf, SilverlightPublic

Component References (1)

 IDTypeParentAccessibility
Microsoft.SQLServer.Linux.Dashboards.SummaryReferenceMicrosoft.SQLServer.Linux.Dashboards.SummaryReferenceMicrosoft.SQLServer.Linux.Dashboards.SummaryMicrosoft.SQLServer.Linux.Folder.DBEnginePublic

Component Types (1)

 DisplayNameIDAccessibility
Microsoft.SQLServer.Linux.Dashboards.SummarySummaryMicrosoft.SQLServer.Linux.Dashboards.SummaryPublic