Microsoft SQL Server on Linux (Views)

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

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

Summary

Microsoft SQL Server on Linux (Views) Management Pack contains views and folder structure for Microsoft SQL Server on Linux management packs. This Management Pack depends on Microsoft SQL Server 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 contains SQL Server Agent RelationshipMicrosoft.SQLServer.Linux.AllSQLServerObjectsGroupContainsAgentMicrosoft.SQLServer.Linux.AllSQLServerObjectsGroupMicrosoft.SQLServer.Linux.AgentInternalFalse
Microsoft.SQLServer.Linux.AllSQLServerObjectsGroupContainsDBEngineMSSQL on Linux: All SQL Server Objects Group contains 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 contains 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 contains DB Filegroup RelationshipMicrosoft.SQLServer.Linux.FilegroupsGroupContainsDBFilegroupMicrosoft.SQLServer.Linux.FilegroupsGroupMicrosoft.SQLServer.Linux.DBFilegroupInternalFalse
Microsoft.SQLServer.Linux.FilegroupsGroupContainsDBFilegroupFdMSSQL on Linux: All SQL Server Filegroups Group contains DB FILESTREAM Filegroup RelationshipMicrosoft.SQLServer.Linux.FilegroupsGroupContainsDBFilegroupFdMicrosoft.SQLServer.Linux.FilegroupsGroupMicrosoft.SQLServer.Linux.DBFilegroupFdInternalFalse
Microsoft.SQLServer.Linux.FilegroupsGroupContainsDBFilegroupFxMSSQL on Linux: All SQL Server Filegroups Group contains 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 (14)

 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

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 (15)

 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

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

Linked Reports (8)

 DisplayNameIDBaseTargetAccessibilityVisible
Microsoft.SQLServer.Linux.Views.Report.BrokerPerformanceSQL Broker PerformanceMicrosoft.SQLServer.Linux.Views.Report.BrokerPerformanceMicrosoft.SystemCenter.DataWarehouse.Report.PerformanceMicrosoft.SQLServer.Linux.DBEnginePublicTrue
Microsoft.SQLServer.Linux.Views.Report.DatabaseCountersSQL Server Database Engine CountersMicrosoft.SQLServer.Linux.Views.Report.DatabaseCountersMicrosoft.SystemCenter.DataWarehouse.Report.PerformanceMicrosoft.SQLServer.Linux.DBEnginePublicTrue
Microsoft.SQLServer.Linux.Views.Report.LockAnalysisSQL Server Lock AnalysisMicrosoft.SQLServer.Linux.Views.Report.LockAnalysisMicrosoft.SystemCenter.DataWarehouse.Report.PerformanceMicrosoft.SQLServer.Linux.DBEnginePublicTrue
Microsoft.SQLServer.Linux.Views.Report.SQLServerConfigurationSQL Server ConfigurationMicrosoft.SQLServer.Linux.Views.Report.SQLServerConfigurationMicrosoft.SystemCenter.DataWarehouse.Report.CustomConfigurationMicrosoft.SQLServer.Linux.DBEnginePublicTrue
Microsoft.SQLServer.Linux.Views.Report.TopDeadlockedDatabasesTop 5 Deadlocked DatabasesMicrosoft.SQLServer.Linux.Views.Report.TopDeadlockedDatabasesMicrosoft.SystemCenter.DataWarehouse.Report.PerformanceTopMicrosoft.SQLServer.Linux.DBEnginePublicTrue
Microsoft.SQLServer.Linux.Views.Report.UserActivitySQL User ActivityMicrosoft.SQLServer.Linux.Views.Report.UserActivityMicrosoft.SystemCenter.DataWarehouse.Report.PerformanceMicrosoft.SQLServer.Linux.DBEnginePublicTrue
Microsoft.SQLServer.Linux.Views.Report.UserConnectionsByDayUser connections by dayMicrosoft.SQLServer.Linux.Views.Report.UserConnectionsByDayMicrosoft.SystemCenter.DataWarehouse.Report.PerformanceMicrosoft.SQLServer.Linux.DBEnginePublicTrue
Microsoft.SQLServer.Linux.Views.Report.UserConnectionsByPeakHoursUser connections by peak hoursMicrosoft.SQLServer.Linux.Views.Report.UserConnectionsByPeakHoursMicrosoft.SystemCenter.DataWarehouse.Report.PerformanceMicrosoft.SQLServer.Linux.DBEnginePublicTrue