This Management Pack contains views and folder structure for Microsoft SQL Server 2017 on Linux management packs.
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.
| DisplayName | ID | Base Class | Abstract | Hosted | Singleton | Group | Extension | Accessibility | |
|---|---|---|---|---|---|---|---|---|---|
 | MSSQL 2017 on Linux: All SQL Server Objects Group | Microsoft.SQLServer.2017.Linux.AllSQLServerObjectsGroup | System.Group | False | False | True | True | False | Public |
| MSSQL 2017 on Linux: All SQL Server Filegroups Group | Microsoft.SQLServer.2017.Linux.FilegroupsGroup | System.Group | False | False | True | True | False | Public |
| MSSQL 2017 on Linux: Memory-Optimized Data Resource Pool Group | Microsoft.SQLServer.2017.Linux.InMemoryOLTPResourcePoolGroup | System.Group | False | False | True | True | False | Public |
| MSSQL 2017 on Linux: Memory-Optimized Data Scope Group | Microsoft.SQLServer.2017.Linux.InMemoryOLTPScopeGroup | System.Group | False | False | True | True | False | Public |
| DisplayName | ID | Source | Target | Accessibility | Abstract | |
|---|---|---|---|---|---|---|
 | MSSQL 2017 on Linux: All SQL Server Objects Group сontains SQL Server 2017 Agent Relationship | Microsoft.SQLServer.2017.Linux.AllSQLServerObjectsGroupContainsAgent | Microsoft.SQLServer.2017.Linux.AllSQLServerObjectsGroup | Microsoft.SQLServer.2017.Linux.Agent | Internal | False |
| MSSQL 2017 on Linux: All SQL Server Objects Group сontains SQL Server 2017 DB Engine Relationship | Microsoft.SQLServer.2017.Linux.AllSQLServerObjectsGroupContainsDBEngine | Microsoft.SQLServer.2017.Linux.AllSQLServerObjectsGroup | Microsoft.SQLServer.2017.Linux.DBEngine | Internal | False |
| MSSQL 2017 on Linux: All SQL Server objects Group сontains SQL Server 2017 Monitoring Pool Alert Collection Relationship | Microsoft.SQLServer.2017.Linux.AllSQLServerObjectsGroupContainsMonitoringPoolAlertCollection | Microsoft.SQLServer.2017.Linux.AllSQLServerObjectsGroup | Microsoft.SQLServer.2017.Linux.MonitoringPoolAlertCollection | Internal | False |
| MSSQL 2017 on Linux: All SQL Server Filegroups Group сontains DB Filegroup Relationship | Microsoft.SQLServer.2017.Linux.FilegroupsGroupContainsDBFilegroup | Microsoft.SQLServer.2017.Linux.FilegroupsGroup | Microsoft.SQLServer.2017.Linux.DBFilegroup | Internal | False |
| MSSQL 2017 on Linux: All SQL Server Filegroups Group сontains DB FILESTREAM Filegroup Relationship | Microsoft.SQLServer.2017.Linux.FilegroupsGroupContainsDBFilegroupFd | Microsoft.SQLServer.2017.Linux.FilegroupsGroup | Microsoft.SQLServer.2017.Linux.DBFilegroupFd | Internal | False |
| MSSQL 2017 on Linux: All SQL Server Filegroups Group сontains DB Memory-Optimized Data Filegroup Relationship | Microsoft.SQLServer.2017.Linux.FilegroupsGroupContainsDBFilegroupFx | Microsoft.SQLServer.2017.Linux.FilegroupsGroup | Microsoft.SQLServer.2017.Linux.DBFilegroupFx | Internal | False |
| MSSQL 2017 on Linux: SQL Server 2017 Memory-Optimized Data Resource Pool Group contains SQL Server 2017 Resource Pool on Linux Relationship | Microsoft.SQLServer.2017.Linux.InMemoryOLTPResourcePoolGroupContainsResourcePool | Microsoft.SQLServer.2017.Linux.InMemoryOLTPResourcePoolGroup | Microsoft.SQLServer.2017.Linux.ResourcePool | Internal | False |
| MSSQL 2017 on Linux: SQL Server 2017 Memory-Optimized Data Scope Group contains SQL Server 2017 DB Memory-Optimized Data Filegroup Relationship | Microsoft.SQLServer.2017.Linux.InMemoryOLTPScopeGroupContainsDBFilegroupFx | Microsoft.SQLServer.2017.Linux.InMemoryOLTPScopeGroup | Microsoft.SQLServer.2017.Linux.DBFilegroupFx | Internal | False |
| MSSQL 2017 on Linux: SQL Server 2017 Memory-Optimized Data Scope Group contains SQL Server 2017 Memory-Optimized Data Resource Pool Group Relationship | Microsoft.SQLServer.2017.Linux.InMemoryOLTPScopeGroupContainsInMemoryOLTPResourcePoolGroup | Microsoft.SQLServer.2017.Linux.InMemoryOLTPScopeGroup | Microsoft.SQLServer.2017.Linux.InMemoryOLTPResourcePoolGroup | Internal | False |
| DisplayName | ID | Target | Enabled | |
|---|---|---|---|---|
 | MSSQL 2017 on Linux: All SQL Server Objects Group Discovery | Microsoft.SQLServer.2017.Linux.Discovery.AllSQLServerObjectsGroup | Microsoft.SQLServer.2017.Linux.AllSQLServerObjectsGroup | True |
| MSSQL 2017 on Linux: All SQL Server Filegroups Group Discovery | Microsoft.SQLServer.2017.Linux.Discovery.FilegroupsGroup | Microsoft.SQLServer.2017.Linux.FilegroupsGroup | True |
| MSSQL 2017 on Linux: SQL Server 2017 Memory-Optimized Data Resource Pool Group Discovery | Microsoft.SQLServer.2017.Linux.Discovery.InMemoryOLTPResourcePoolGroup | Microsoft.SQLServer.2017.Linux.InMemoryOLTPResourcePoolGroup | True |
| MSSQL 2017 on Linux: Memory-Optimized Data Scope Group Discovery | Microsoft.SQLServer.2017.Linux.Discovery.InMemoryOLTPScopeGroup | Microsoft.SQLServer.2017.Linux.InMemoryOLTPScopeGroup | True |
| ID | FolderName | ElementID | |
|---|---|---|---|
 | Microsoft.SQLServer.2017.Linux.FolderItem.Agent.AlertsView | Microsoft.SQLServer.2017.Linux.Folder.Agent | Microsoft.SQLServer.2017.Linux.View.Agent.AlertsView |
| Microsoft.SQLServer.2017.Linux.FolderItem.Agent.StateView | Microsoft.SQLServer.2017.Linux.Folder.Agent | Microsoft.SQLServer.2017.Linux.View.Agent.StateView |
| Microsoft.SQLServer.2017.Linux.FolderItem.AgentJob.StateView | Microsoft.SQLServer.2017.Linux.Folder.Agent | Microsoft.SQLServer.2017.Linux.View.AgentJob.StateView |
| Microsoft.SQLServer.2017.Linux.FolderItem.Container.StateView | Microsoft.SQLServer.2017.Linux.Folder.InMemoryOLTP | Microsoft.SQLServer.2017.Linux.View.Container.StateView |
| Microsoft.SQLServer.2017.Linux.FolderItem.Database.StateView | Microsoft.SQLServer.2017.Linux.Folder.DBEngine | Microsoft.SQLServer.2017.Linux.View.Filegroup.StateView |
| Microsoft.SQLServer.2017.Linux.FolderItem.DBEngine.StateView | Microsoft.SQLServer.2017.Linux.Folder.DBEngine | Microsoft.SQLServer.2017.Linux.View.DBEngine.StateView |
| Microsoft.SQLServer.2017.Linux.FolderItem.DBFilegroupFx.StateView | Microsoft.SQLServer.2017.Linux.Folder.InMemoryOLTP | Microsoft.SQLServer.2017.Linux.View.DBFilegroupFx.StateView |
| Microsoft.SQLServer.2017.Linux.FolderItem.InMemoryOLTP.AlertsView | Microsoft.SQLServer.2017.Linux.Folder.InMemoryOLTP | Microsoft.SQLServer.2017.Linux.View.InMemoryOLTP.AlertsView |
| Microsoft.SQLServer.2017.Linux.FolderItem.InMemoryOLTP.AllPerformance | Microsoft.SQLServer.2017.Linux.Folder.InMemoryOLTP | Microsoft.SQLServer.2017.Linux.View.InMemoryOLTP.AllPerformance |
| Microsoft.SQLServer.2017.Linux.FolderItem.InMemoryOLTPResourcePool.StateView | Microsoft.SQLServer.2017.Linux.Folder.InMemoryOLTP | Microsoft.SQLServer.2017.Linux.View.InMemoryOLTPResourcePool.StateView |
| DisplayName | ID | ParentFolder | Accessibility | |
|---|---|---|---|---|
| SQL Agent on Linux | Microsoft.SQLServer.2017.Linux.Folder.Agent | Microsoft.SQLServer.2017.Library.Folder.Agent | Public |
| Database Engines on Linux | Microsoft.SQLServer.2017.Linux.Folder.DBEngine | Microsoft.SQLServer.2017.Library.Folder.DBEngine | Public |
| Memory-Optimized Data on Linux | Microsoft.SQLServer.2017.Linux.Folder.InMemoryOLTP | Microsoft.SQLServer.2017.Library.Folder.InMemoryOLTP | Public |
| DisplayName | ID | Target | Type | Accessibility | Visible | |
|---|---|---|---|---|---|---|
 | Active Alerts | Microsoft.SQLServer.2017.Linux.View.Agent.AlertsView | Microsoft.SQLServer.2017.Linux.Agent | Microsoft.SystemCenter.AlertViewType | Public | True |
 | SQL Agents | Microsoft.SQLServer.2017.Linux.View.Agent.StateView | Microsoft.SQLServer.2017.Linux.Agent | Microsoft.SystemCenter.StateViewType | Public | True |
| SQL Agent Jobs | Microsoft.SQLServer.2017.Linux.View.AgentJob.StateView | Microsoft.SQLServer.2017.Linux.AgentJob | Microsoft.SystemCenter.StateViewType | Public | True |
| Memory-Optimized Data Filegroup Containers | Microsoft.SQLServer.2017.Linux.View.Container.StateView | Microsoft.SQLServer.2017.Linux.Container | Microsoft.SystemCenter.StateViewType | Public | True |
| Databases | Microsoft.SQLServer.2017.Linux.View.Database.StateView | Microsoft.SQLServer.2017.Linux.Database | Microsoft.SystemCenter.StateViewType | Public | True |
| Database Engines | Microsoft.SQLServer.2017.Linux.View.DBEngine.StateView | Microsoft.SQLServer.2017.Linux.DBEngine | Microsoft.SystemCenter.StateViewType | Public | True |
| Memory-Optimized Data Filegroups | Microsoft.SQLServer.2017.Linux.View.DBFilegroupFx.StateView | Microsoft.SQLServer.2017.Linux.DBFilegroupFx | Microsoft.SystemCenter.StateViewType | Public | True |
| Filegroups | Microsoft.SQLServer.2017.Linux.View.Filegroup.StateView | Microsoft.SQLServer.2017.Library.Filegroup | Microsoft.SystemCenter.StateViewType | Public | True |
| Active Alerts | Microsoft.SQLServer.2017.Linux.View.InMemoryOLTP.AlertsView | Microsoft.SQLServer.2017.Linux.InMemoryOLTPScopeGroup | Microsoft.SystemCenter.AlertViewType | Public | True |
 | All Performance Data | Microsoft.SQLServer.2017.Linux.View.InMemoryOLTP.AllPerformance | Microsoft.SQLServer.2017.Linux.InMemoryOLTPScopeGroup | Microsoft.SystemCenter.PerformanceViewType | Public | True |
| Resource Pools | Microsoft.SQLServer.2017.Linux.View.InMemoryOLTPResourcePool.StateView | Microsoft.SQLServer.2017.Linux.ResourcePool | Microsoft.SystemCenter.StateViewType | Public | True |
Home
Show Management Pack References