Microsoft SQL Server 2017 on Linux (Views)

Microsoft.SQLServer.2017.Linux.Views :: 6.7.60.0 (Management Pack)

This Management Pack contains views and folder structure for Microsoft SQL Server 2017 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 2017 Library (Views) Management Pack.

Management Pack Elements

Classes (4)

 DisplayNameIDBase ClassAbstractHostedSingletonGroupExtensionAccessibility
Microsoft.SQLServer.2017.Linux.AllSQLServerObjectsGroupMSSQL 2017 on Linux: All SQL Server Objects GroupMicrosoft.SQLServer.2017.Linux.AllSQLServerObjectsGroupSystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2017.Linux.FilegroupsGroupMSSQL 2017 on Linux: All SQL Server Filegroups GroupMicrosoft.SQLServer.2017.Linux.FilegroupsGroupSystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2017.Linux.InMemoryOLTPResourcePoolGroupMSSQL 2017 on Linux: Memory-Optimized Data Resource Pool GroupMicrosoft.SQLServer.2017.Linux.InMemoryOLTPResourcePoolGroupSystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2017.Linux.InMemoryOLTPScopeGroupMSSQL 2017 on Linux: Memory-Optimized Data Scope GroupMicrosoft.SQLServer.2017.Linux.InMemoryOLTPScopeGroupSystem.GroupFalseFalseTrueTrueFalsePublic

Relationship Types (9)

 DisplayNameIDSourceTargetAccessibilityAbstract
Microsoft.SQLServer.2017.Linux.AllSQLServerObjectsGroupContainsAgentMSSQL 2017 on Linux: All SQL Server Objects Group сontains SQL Server 2017 Agent RelationshipMicrosoft.SQLServer.2017.Linux.AllSQLServerObjectsGroupContainsAgentMicrosoft.SQLServer.2017.Linux.AllSQLServerObjectsGroupMicrosoft.SQLServer.2017.Linux.AgentInternalFalse
Microsoft.SQLServer.2017.Linux.AllSQLServerObjectsGroupContainsDBEngineMSSQL 2017 on Linux: All SQL Server Objects Group сontains SQL Server 2017 DB Engine RelationshipMicrosoft.SQLServer.2017.Linux.AllSQLServerObjectsGroupContainsDBEngineMicrosoft.SQLServer.2017.Linux.AllSQLServerObjectsGroupMicrosoft.SQLServer.2017.Linux.DBEngineInternalFalse
Microsoft.SQLServer.2017.Linux.AllSQLServerObjectsGroupContainsMonitoringPoolAlertCollectionMSSQL 2017 on Linux: All SQL Server objects Group сontains SQL Server 2017 Monitoring Pool Alert Collection RelationshipMicrosoft.SQLServer.2017.Linux.AllSQLServerObjectsGroupContainsMonitoringPoolAlertCollectionMicrosoft.SQLServer.2017.Linux.AllSQLServerObjectsGroupMicrosoft.SQLServer.2017.Linux.MonitoringPoolAlertCollectionInternalFalse
Microsoft.SQLServer.2017.Linux.FilegroupsGroupContainsDBFilegroupMSSQL 2017 on Linux: All SQL Server Filegroups Group сontains DB Filegroup RelationshipMicrosoft.SQLServer.2017.Linux.FilegroupsGroupContainsDBFilegroupMicrosoft.SQLServer.2017.Linux.FilegroupsGroupMicrosoft.SQLServer.2017.Linux.DBFilegroupInternalFalse
Microsoft.SQLServer.2017.Linux.FilegroupsGroupContainsDBFilegroupFdMSSQL 2017 on Linux: All SQL Server Filegroups Group сontains DB FILESTREAM Filegroup RelationshipMicrosoft.SQLServer.2017.Linux.FilegroupsGroupContainsDBFilegroupFdMicrosoft.SQLServer.2017.Linux.FilegroupsGroupMicrosoft.SQLServer.2017.Linux.DBFilegroupFdInternalFalse
Microsoft.SQLServer.2017.Linux.FilegroupsGroupContainsDBFilegroupFxMSSQL 2017 on Linux: All SQL Server Filegroups Group сontains DB Memory-Optimized Data Filegroup RelationshipMicrosoft.SQLServer.2017.Linux.FilegroupsGroupContainsDBFilegroupFxMicrosoft.SQLServer.2017.Linux.FilegroupsGroupMicrosoft.SQLServer.2017.Linux.DBFilegroupFxInternalFalse
Microsoft.SQLServer.2017.Linux.InMemoryOLTPResourcePoolGroupContainsResourcePoolMSSQL 2017 on Linux: SQL Server 2017 Memory-Optimized Data Resource Pool Group contains SQL Server 2017 Resource Pool on Linux RelationshipMicrosoft.SQLServer.2017.Linux.InMemoryOLTPResourcePoolGroupContainsResourcePoolMicrosoft.SQLServer.2017.Linux.InMemoryOLTPResourcePoolGroupMicrosoft.SQLServer.2017.Linux.ResourcePoolInternalFalse
Microsoft.SQLServer.2017.Linux.InMemoryOLTPScopeGroupContainsDBFilegroupFxMSSQL 2017 on Linux: SQL Server 2017 Memory-Optimized Data Scope Group contains SQL Server 2017 DB Memory-Optimized Data Filegroup RelationshipMicrosoft.SQLServer.2017.Linux.InMemoryOLTPScopeGroupContainsDBFilegroupFxMicrosoft.SQLServer.2017.Linux.InMemoryOLTPScopeGroupMicrosoft.SQLServer.2017.Linux.DBFilegroupFxInternalFalse
Microsoft.SQLServer.2017.Linux.InMemoryOLTPScopeGroupContainsInMemoryOLTPResourcePoolGroupMSSQL 2017 on Linux: SQL Server 2017 Memory-Optimized Data Scope Group contains SQL Server 2017 Memory-Optimized Data Resource Pool Group RelationshipMicrosoft.SQLServer.2017.Linux.InMemoryOLTPScopeGroupContainsInMemoryOLTPResourcePoolGroupMicrosoft.SQLServer.2017.Linux.InMemoryOLTPScopeGroupMicrosoft.SQLServer.2017.Linux.InMemoryOLTPResourcePoolGroupInternalFalse

Discoveries (4)

 DisplayNameIDTargetEnabled
Microsoft.SQLServer.2017.Linux.Discovery.AllSQLServerObjectsGroupMSSQL 2017 on Linux: All SQL Server Objects Group DiscoveryMicrosoft.SQLServer.2017.Linux.Discovery.AllSQLServerObjectsGroupMicrosoft.SQLServer.2017.Linux.AllSQLServerObjectsGroupTrue
Microsoft.SQLServer.2017.Linux.Discovery.FilegroupsGroupMSSQL 2017 on Linux: All SQL Server Filegroups Group DiscoveryMicrosoft.SQLServer.2017.Linux.Discovery.FilegroupsGroupMicrosoft.SQLServer.2017.Linux.FilegroupsGroupTrue
Microsoft.SQLServer.2017.Linux.Discovery.InMemoryOLTPResourcePoolGroupMSSQL 2017 on Linux: SQL Server 2017 Memory-Optimized Data Resource Pool Group DiscoveryMicrosoft.SQLServer.2017.Linux.Discovery.InMemoryOLTPResourcePoolGroupMicrosoft.SQLServer.2017.Linux.InMemoryOLTPResourcePoolGroupTrue
Microsoft.SQLServer.2017.Linux.Discovery.InMemoryOLTPScopeGroupMSSQL 2017 on Linux: Memory-Optimized Data Scope Group DiscoveryMicrosoft.SQLServer.2017.Linux.Discovery.InMemoryOLTPScopeGroupMicrosoft.SQLServer.2017.Linux.InMemoryOLTPScopeGroupTrue

Folder Items (10)

 IDFolderNameElementID
Microsoft.SQLServer.2017.Linux.FolderItem.Agent.AlertsViewMicrosoft.SQLServer.2017.Linux.FolderItem.Agent.AlertsViewMicrosoft.SQLServer.2017.Linux.Folder.AgentMicrosoft.SQLServer.2017.Linux.View.Agent.AlertsView
Microsoft.SQLServer.2017.Linux.FolderItem.Agent.StateViewMicrosoft.SQLServer.2017.Linux.FolderItem.Agent.StateViewMicrosoft.SQLServer.2017.Linux.Folder.AgentMicrosoft.SQLServer.2017.Linux.View.Agent.StateView
Microsoft.SQLServer.2017.Linux.FolderItem.AgentJob.StateViewMicrosoft.SQLServer.2017.Linux.FolderItem.AgentJob.StateViewMicrosoft.SQLServer.2017.Linux.Folder.AgentMicrosoft.SQLServer.2017.Linux.View.AgentJob.StateView
Microsoft.SQLServer.2017.Linux.FolderItem.Container.StateViewMicrosoft.SQLServer.2017.Linux.FolderItem.Container.StateViewMicrosoft.SQLServer.2017.Linux.Folder.InMemoryOLTPMicrosoft.SQLServer.2017.Linux.View.Container.StateView
Microsoft.SQLServer.2017.Linux.FolderItem.Database.StateViewMicrosoft.SQLServer.2017.Linux.FolderItem.Database.StateViewMicrosoft.SQLServer.2017.Linux.Folder.DBEngineMicrosoft.SQLServer.2017.Linux.View.Filegroup.StateView
Microsoft.SQLServer.2017.Linux.FolderItem.DBEngine.StateViewMicrosoft.SQLServer.2017.Linux.FolderItem.DBEngine.StateViewMicrosoft.SQLServer.2017.Linux.Folder.DBEngineMicrosoft.SQLServer.2017.Linux.View.DBEngine.StateView
Microsoft.SQLServer.2017.Linux.FolderItem.DBFilegroupFx.StateViewMicrosoft.SQLServer.2017.Linux.FolderItem.DBFilegroupFx.StateViewMicrosoft.SQLServer.2017.Linux.Folder.InMemoryOLTPMicrosoft.SQLServer.2017.Linux.View.DBFilegroupFx.StateView
Microsoft.SQLServer.2017.Linux.FolderItem.InMemoryOLTP.AlertsViewMicrosoft.SQLServer.2017.Linux.FolderItem.InMemoryOLTP.AlertsViewMicrosoft.SQLServer.2017.Linux.Folder.InMemoryOLTPMicrosoft.SQLServer.2017.Linux.View.InMemoryOLTP.AlertsView
Microsoft.SQLServer.2017.Linux.FolderItem.InMemoryOLTP.AllPerformanceMicrosoft.SQLServer.2017.Linux.FolderItem.InMemoryOLTP.AllPerformanceMicrosoft.SQLServer.2017.Linux.Folder.InMemoryOLTPMicrosoft.SQLServer.2017.Linux.View.InMemoryOLTP.AllPerformance
Microsoft.SQLServer.2017.Linux.FolderItem.InMemoryOLTPResourcePool.StateViewMicrosoft.SQLServer.2017.Linux.FolderItem.InMemoryOLTPResourcePool.StateViewMicrosoft.SQLServer.2017.Linux.Folder.InMemoryOLTPMicrosoft.SQLServer.2017.Linux.View.InMemoryOLTPResourcePool.StateView

Folders (3)

 DisplayNameIDParentFolderAccessibility
Microsoft.SQLServer.2017.Linux.Folder.AgentSQL Agent on LinuxMicrosoft.SQLServer.2017.Linux.Folder.AgentMicrosoft.SQLServer.2017.Library.Folder.AgentPublic
Microsoft.SQLServer.2017.Linux.Folder.DBEngineDatabase Engines on LinuxMicrosoft.SQLServer.2017.Linux.Folder.DBEngineMicrosoft.SQLServer.2017.Library.Folder.DBEnginePublic
Microsoft.SQLServer.2017.Linux.Folder.InMemoryOLTPMemory-Optimized Data on LinuxMicrosoft.SQLServer.2017.Linux.Folder.InMemoryOLTPMicrosoft.SQLServer.2017.Library.Folder.InMemoryOLTPPublic

Views (11)

 DisplayNameIDTargetTypeAccessibilityVisible
Microsoft.SQLServer.2017.Linux.View.Agent.AlertsViewActive AlertsMicrosoft.SQLServer.2017.Linux.View.Agent.AlertsViewMicrosoft.SQLServer.2017.Linux.AgentMicrosoft.SystemCenter.AlertViewTypePublicTrue
Microsoft.SQLServer.2017.Linux.View.Agent.StateViewSQL AgentsMicrosoft.SQLServer.2017.Linux.View.Agent.StateViewMicrosoft.SQLServer.2017.Linux.AgentMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2017.Linux.View.AgentJob.StateViewSQL Agent JobsMicrosoft.SQLServer.2017.Linux.View.AgentJob.StateViewMicrosoft.SQLServer.2017.Linux.AgentJobMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2017.Linux.View.Container.StateViewMemory-Optimized Data Filegroup ContainersMicrosoft.SQLServer.2017.Linux.View.Container.StateViewMicrosoft.SQLServer.2017.Linux.ContainerMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2017.Linux.View.Database.StateViewDatabasesMicrosoft.SQLServer.2017.Linux.View.Database.StateViewMicrosoft.SQLServer.2017.Linux.DatabaseMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2017.Linux.View.DBEngine.StateViewDatabase EnginesMicrosoft.SQLServer.2017.Linux.View.DBEngine.StateViewMicrosoft.SQLServer.2017.Linux.DBEngineMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2017.Linux.View.DBFilegroupFx.StateViewMemory-Optimized Data FilegroupsMicrosoft.SQLServer.2017.Linux.View.DBFilegroupFx.StateViewMicrosoft.SQLServer.2017.Linux.DBFilegroupFxMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2017.Linux.View.Filegroup.StateViewFilegroupsMicrosoft.SQLServer.2017.Linux.View.Filegroup.StateViewMicrosoft.SQLServer.2017.Library.FilegroupMicrosoft.SystemCenter.StateViewTypePublicTrue
Microsoft.SQLServer.2017.Linux.View.InMemoryOLTP.AlertsViewActive AlertsMicrosoft.SQLServer.2017.Linux.View.InMemoryOLTP.AlertsViewMicrosoft.SQLServer.2017.Linux.InMemoryOLTPScopeGroupMicrosoft.SystemCenter.AlertViewTypePublicTrue
Microsoft.SQLServer.2017.Linux.View.InMemoryOLTP.AllPerformanceAll Performance DataMicrosoft.SQLServer.2017.Linux.View.InMemoryOLTP.AllPerformanceMicrosoft.SQLServer.2017.Linux.InMemoryOLTPScopeGroupMicrosoft.SystemCenter.PerformanceViewTypePublicTrue
Microsoft.SQLServer.2017.Linux.View.InMemoryOLTPResourcePool.StateViewResource PoolsMicrosoft.SQLServer.2017.Linux.View.InMemoryOLTPResourcePool.StateViewMicrosoft.SQLServer.2017.Linux.ResourcePoolMicrosoft.SystemCenter.StateViewTypePublicTrue