This Management Pack discovers Microsoft SQL Server 2017 and related objects on Linux. The management pack only contains the discovery logic and requires the separate monitoring management pack to be imported to monitor the discovered objects.
Microsoft SQL Server 2017 on Linux (Discovery) Management Pack discovers Microsoft SQL Server 2017 and related objects on Linux. It requires Microsoft SQL Server 2017 Core Library Management Pack. The management pack only contains the discovery logic and requires the separate monitoring management pack to be imported to monitor the discovered objects.
| DisplayName | ID | Base Class | Abstract | Hosted | Singleton | Group | Extension | Accessibility | |
|---|---|---|---|---|---|---|---|---|---|
 | MSSQL 2017 on Linux: Agent | Microsoft.SQLServer.2017.Linux.Agent | Microsoft.SQLServer.2017.Library.Agent | False | True | False | False | False | Public |
 | MSSQL 2017 on Linux: Agent Job | Microsoft.SQLServer.2017.Linux.AgentJob | Microsoft.SQLServer.2017.Library.AgentJob | False | True | False | False | False | Public |
 | MSSQL 2017 on Linux: DB Memory-Optimized Data Container | Microsoft.SQLServer.2017.Linux.Container | Microsoft.SQLServer.2017.Library.Container | False | True | False | False | False | Public |
 | MSSQL 2017 on Linux: Database | Microsoft.SQLServer.2017.Linux.Database | Microsoft.SQLServer.2017.Library.Database | False | True | False | False | False | Public |
 | MSSQL 2017 on Linux: Database Critical Policy | Microsoft.SQLServer.2017.Linux.DatabaseErrorUserPolicy | Microsoft.SQLServer.2017.Linux.Policy | False | True | False | False | False | Public |
| MSSQL 2017 on Linux: Database Warning Policy | Microsoft.SQLServer.2017.Linux.DatabaseWarningUserPolicy | Microsoft.SQLServer.2017.Linux.Policy | False | True | False | False | False | Public |
 | MSSQL 2017 on Linux: DB Engine | Microsoft.SQLServer.2017.Linux.DBEngine | Microsoft.SQLServer.2017.Library.DBEngine | False | False | False | False | False | Public |
 | MSSQL 2017 on Linux: DB Engine Express Group | Microsoft.SQLServer.2017.Linux.DBEngineExpressGroup | System.Group | False | False | True | True | False | Public |
| MSSQL 2017 on Linux: DB Engine Group | Microsoft.SQLServer.2017.Linux.DBEngineGroup | System.Group | False | False | True | True | False | Public |
 | MSSQL 2017 on Linux: DB Engine Seed | Microsoft.SQLServer.2017.Linux.DBEngineSeed | System.Entity | False | False | False | False | False | Public |
 | MSSQL 2017 on Linux: DB File | Microsoft.SQLServer.2017.Linux.DBFile | Microsoft.SQLServer.2017.Library.DBFile | False | True | False | False | False | Public |
 | MSSQL 2017 on Linux: DB Filegroup | Microsoft.SQLServer.2017.Linux.DBFilegroup | Microsoft.SQLServer.2017.Library.DBFilegroup | False | True | False | False | False | Public |
| MSSQL 2017 on Linux: DB FILESTREAM Filegroup | Microsoft.SQLServer.2017.Linux.DBFilegroupFd | Microsoft.SQLServer.2017.Library.DBFilegroupFd | False | True | False | False | False | Public |
 | MSSQL 2017 on Linux: DB Memory-Optimized Data Filegroup | Microsoft.SQLServer.2017.Linux.DBFilegroupFx | Microsoft.SQLServer.2017.Library.DBFilegroupFx | False | True | False | False | False | Public |
 | MSSQL 2017 on Linux: DB Log File | Microsoft.SQLServer.2017.Linux.DBLogFile | Microsoft.SQLServer.2017.Library.DBLogFile | False | True | False | False | False | Public |
 | MSSQL 2017 on Linux: Default Resource Pool | Microsoft.SQLServer.2017.Linux.DefaultPool | Microsoft.SQLServer.2017.Linux.UserResourcePool | False | True | False | False | False | Public |
| MSSQL 2017 on Linux: Internal Resource Pool | Microsoft.SQLServer.2017.Linux.InternalPool | Microsoft.SQLServer.2017.Linux.ResourcePool | False | True | False | False | False | Public |
 | MSSQL 2017 on Linux: Monitoring Pool Alert Collection | Microsoft.SQLServer.2017.Linux.MonitoringPoolAlertCollection | Microsoft.SQLServer.2017.Library.MonitoringPoolAlertCollection | False | True | False | False | False | Public |
| MSSQL 2017 on Linux: Custom User Policy | Microsoft.SQLServer.2017.Linux.Policy | Microsoft.SQLServer.2017.Library.Policy | True | False | False | False | False | Public |
| MSSQL 2017 on Linux: Resource Pool | Microsoft.SQLServer.2017.Linux.ResourcePool | Microsoft.SQLServer.2017.Library.ResourcePool | True | True | False | False | False | Public |
| MSSQL 2017 on Linux: Resource Pool Group | Microsoft.SQLServer.2017.Linux.ResourcePoolGroup | System.Entity | False | True | False | False | False | Public |
| MSSQL 2017 on Linux: User-Defined Resource Pool | Microsoft.SQLServer.2017.Linux.UserDefinedPool | Microsoft.SQLServer.2017.Linux.UserResourcePool | False | True | False | False | False | Public |
| MSSQL 2017 on Linux: User Resource Pool | Microsoft.SQLServer.2017.Linux.UserResourcePool | Microsoft.SQLServer.2017.Linux.ResourcePool | True | True | False | False | False | Public |
| DisplayName | ID | Source | Target | Accessibility | Abstract | |
|---|---|---|---|---|---|---|
 | MSSQL 2017 on Linux: Agent Hosts SQL Server 2017 Agent Job | Microsoft.SQLServer.2017.Linux.AgentHostsAgentJob | Microsoft.SQLServer.2017.Linux.Agent | Microsoft.SQLServer.2017.Linux.AgentJob | Public | False |
| MSSQL 2017 on Linux: DB Hosts SQL Server 2017 Database Critical Policy | Microsoft.SQLServer.2017.Linux.DatabaseHostsDBErrorUserPolicy | Microsoft.SQLServer.2017.Linux.Database | Microsoft.SQLServer.2017.Linux.DatabaseErrorUserPolicy | Public | False |
| MSSQL 2017 on Linux: DB Hosts SQL Server 2017 DB Filegroup | Microsoft.SQLServer.2017.Linux.DatabaseHostsDBFilegroup | Microsoft.SQLServer.2017.Linux.Database | Microsoft.SQLServer.2017.Linux.DBFilegroup | Public | False |
| MSSQL 2017 on Linux: DB Hosts SQL Server 2017 DB FILESTREAM Filegroup | Microsoft.SQLServer.2017.Linux.DatabaseHostsDBFilegroupFd | Microsoft.SQLServer.2017.Linux.Database | Microsoft.SQLServer.2017.Linux.DBFilegroupFd | Public | False |
| MSSQL 2017 on Linux: DB Hosts SQL Server 2017 DB Memory-Optimized Data Filegroup | Microsoft.SQLServer.2017.Linux.DatabaseHostsDBFilegroupFx | Microsoft.SQLServer.2017.Linux.Database | Microsoft.SQLServer.2017.Linux.DBFilegroupFx | Public | False |
| MSSQL 2017 on Linux: DB Hosts SQL Server 2017 DB Log File | Microsoft.SQLServer.2017.Linux.DatabaseHostsDBLogFile | Microsoft.SQLServer.2017.Linux.Database | Microsoft.SQLServer.2017.Linux.DBLogFile | Public | False |
| MSSQL 2017 on Linux: DB Hosts SQL Server 2017 Database Warning Policy | Microsoft.SQLServer.2017.Linux.DatabaseHostsDBWarningUserPolicy | Microsoft.SQLServer.2017.Linux.Database | Microsoft.SQLServer.2017.Linux.DatabaseWarningUserPolicy | Public | False |
| MSSQL 2017 on Linux: Database References User Resource Pool | Microsoft.SQLServer.2017.Linux.DatabaseReferencesUserResourcePool | Microsoft.SQLServer.2017.Linux.Database | Microsoft.SQLServer.2017.Linux.UserResourcePool | Public | False |
| MSSQL 2017 on Linux: DB Engine Express Group Contains SQL Server 2017 DB Engine | Microsoft.SQLServer.2017.Linux.DBEngineExpressGroupContainsDBEngine | Microsoft.SQLServer.2017.Linux.DBEngineExpressGroup | Microsoft.SQLServer.2017.Linux.DBEngine | Public | False |
| MSSQL 2017 on Linux: DB Engine Group Contains SQL Server 2017 DB Engine | Microsoft.SQLServer.2017.Linux.DBEngineGroupContainsDBEngine | Microsoft.SQLServer.2017.Linux.DBEngineGroup | Microsoft.SQLServer.2017.Linux.DBEngine | Public | False |
| MSSQL 2017 on Linux: DB Engine Hosts SQL Server 2017 Agent | Microsoft.SQLServer.2017.Linux.DBEngineHostsAgent | Microsoft.SQLServer.2017.Linux.DBEngine | Microsoft.SQLServer.2017.Linux.Agent | Public | False |
| MSSQL 2017 on Linux: DB Engine Hosts SQL Server 2017 DB | Microsoft.SQLServer.2017.Linux.DBEngineHostsDatabase | Microsoft.SQLServer.2017.Linux.DBEngine | Microsoft.SQLServer.2017.Linux.Database | Public | False |
| MSSQL 2017 on Linux: DB Engine Hosts SQL Server 2017 Resource Pool Group | Microsoft.SQLServer.2017.Linux.DBEngineHostsResourcePoolGroup | Microsoft.SQLServer.2017.Linux.DBEngine | Microsoft.SQLServer.2017.Linux.ResourcePoolGroup | Public | False |
| MSSQL 2017 on Linux: DB Engine Seed Contains SQL Server 2017 DB Engine | Microsoft.SQLServer.2017.Linux.DBEngineSeedContainsDBEngine | Microsoft.SQLServer.2017.Linux.DBEngineSeed | Microsoft.SQLServer.2017.Linux.DBEngine | Public | False |
| MSSQL 2017 on Linux: DB Filegroup Hosts SQL Server 2017 DB Memory-Optimized Data Container | Microsoft.SQLServer.2017.Linux.DBFilegroupFxHostsContainer | Microsoft.SQLServer.2017.Linux.DBFilegroupFx | Microsoft.SQLServer.2017.Linux.Container | Public | False |
| MSSQL 2017 on Linux: DB Filegroup Hosts SQL Server 2017 DB File | Microsoft.SQLServer.2017.Linux.DBFilegroupHostsDBFile | Microsoft.SQLServer.2017.Linux.DBFilegroup | Microsoft.SQLServer.2017.Linux.DBFile | Public | False |
| MSSQL 2017 on Linux: Resource Pool Group Hosts SQL Server 2017 Resource Pool | Microsoft.SQLServer.2017.Linux.ResourcePoolGroupHostsResourcePool | Microsoft.SQLServer.2017.Linux.ResourcePoolGroup | Microsoft.SQLServer.2017.Linux.ResourcePool | Public | False |
| ID | Isolation | Accessibility | |
|---|---|---|---|
 | Microsoft.SQLServer.2017.Linux.ConditionDetection.DatabaseResourcePoolDataMapper | Any | Public |
| Microsoft.SQLServer.2017.Linux.ConditionDetection.ResourcePoolDiscoveryFilter | Any | Internal |
| Microsoft.SQLServer.2017.Linux.Discovery.DiscoveryDataMapper | Any | Public |
| DisplayName | ID | Isolation | Accessibility | |
|---|---|---|---|---|
 | MSSQL 2017 on Linux: Agent Discovery Data Source | Microsoft.SQLServer.2017.Linux.DataSource.AgentDiscovery | Any | Internal |
| MSSQL 2017 on Linux: Agent Job Discovery Data Source | Microsoft.SQLServer.2017.Linux.DataSource.AgentJobDiscovery | Any | Internal |
| MSSQL 2017 on Linux: Container Discovery Data Source | Microsoft.SQLServer.2017.Linux.DataSource.ContainerDiscovery | Any | Internal |
| MSSQL 2017 on Linux: Database Discovery Data Source | Microsoft.SQLServer.2017.Linux.DataSource.DatabaseDiscovery | Any | Internal |
| SQL Server 2017 Data Source Database Memory-Optimized Data Resource Pools on Linux | Microsoft.SQLServer.2017.Linux.DataSource.DatabaseResourcePool | Any | Internal |
| MSSQL 2017 on Linux: Custom User Policy Discovery Data Source | Microsoft.SQLServer.2017.Linux.DataSource.DatabaseUserPolicyDiscovery | Any | Internal |
| MSSQL 2017 on Linux: Custom User Policy DiscoveryCD Data Source | Microsoft.SQLServer.2017.Linux.DataSource.DatabaseUserPolicyDiscoveryProbe | Any | Internal |
| MSSQL 2017 on Linux: DB Engine Discovery Data Source | Microsoft.SQLServer.2017.Linux.DataSource.DBEngineDiscovery | Any | Public |
| MSSQL 2017 on Linux: DB File Discovery Data Source | Microsoft.SQLServer.2017.Linux.DataSource.DBFileDiscovery | Any | Internal |
| MSSQL 2017 on Linux: DB File Discovery Data Source | Microsoft.SQLServer.2017.Linux.DataSource.DBFileDiscoveryProbe | Any | Internal |
| MSSQL 2017 on Linux: DB Filegroup Discovery Data Source | Microsoft.SQLServer.2017.Linux.DataSource.DBFilegroupDiscovery | Any | Internal |
| MSSQL 2017 on Linux: DB Filegroup DiscoveryCD Data Source | Microsoft.SQLServer.2017.Linux.DataSource.DBFilegroupDiscoveryProbe | Any | Internal |
| MSSQL 2017 on Linux: DB FILESTREAM Filegroup Discovery Data Source | Microsoft.SQLServer.2017.Linux.DataSource.DBFilegroupFdDiscovery | Any | Internal |
| MSSQL 2017 on Linux: Memory-Optimized Data Filegroup Discovery Data Source | Microsoft.SQLServer.2017.Linux.DataSource.DBFilegroupFxDiscovery | Any | Internal |
| MSSQL 2017 on Linux: Transaction Log File Discovery Data Source | Microsoft.SQLServer.2017.Linux.DataSource.DBLogFileDiscovery | Any | Internal |
| SQL Server 2017 Data Source Database Engine Resource Pools on Linux | Microsoft.SQLServer.2017.Linux.DataSource.ResourcePool | Any | Internal |
| SQL Server 2017 Data Source Database Engine Resource Pools on Linux | Microsoft.SQLServer.2017.Linux.DataSource.ResourcePoolProbe | Any | Internal |
| DisplayName | ID | Isolation | Accessibility | |
|---|---|---|---|---|
 | MSSQL 2017 on Linux: Agent Probe Discovery | Microsoft.SQLServer.2017.Linux.ProbeAction.AgentDiscovery | Any | Internal |
| MSSQL 2017 on Linux: Agent Job Probe Discovery | Microsoft.SQLServer.2017.Linux.ProbeAction.AgentJobDiscovery | Any | Internal |
| MSSQL 2017 on Linux: Database Probe Discovery | Microsoft.SQLServer.2017.Linux.ProbeAction.DatabaseDiscovery | Any | Internal |
| MSSQL 2017 on Linux: Custom User Policy Probe DiscoveryCD | Microsoft.SQLServer.2017.Linux.ProbeAction.DatabaseUserPolicyDiscoveryCD | Any | Internal |
| MSSQL 2017 DB Engine Probe Discovery on Linux | Microsoft.SQLServer.2017.Linux.ProbeAction.DBEngineDiscovery | Any | Internal |
| MSSQL 2017 on Linux: File Probe DiscoveryCD | Microsoft.SQLServer.2017.Linux.ProbeAction.FileDiscoveryCD | Any | Internal |
| MSSQL 2017 on Linux: Filegroup Probe DiscoveryCD | Microsoft.SQLServer.2017.Linux.ProbeAction.FilegroupDiscoveryCD | Any | Internal |
| Microsoft SQL Server 2017 ResourcePool Probe on Linux | Microsoft.SQLServer.2017.Linux.ProbeAction.ResourcePool | Any | Internal |
| ID | Accessibility | |
|---|---|---|
 | Microsoft.SQLServer.2017.Linux.Discovery.DiscoveryDataMapperSchema | Public |
| DisplayName | ID | Target | Enabled | |
|---|---|---|---|---|
 | MSSQL 2017 on Linux: Discover SQL Server 2017 Agent for a Database Engine | Microsoft.SQLServer.2017.Linux.Discovery.Agent | Microsoft.SQLServer.2017.Linux.DBEngine | True |
| MSSQL 2017 on Linux: Discover SQL Server 2017 Agent Jobs | Microsoft.SQLServer.2017.Linux.Discovery.AgentJob | Microsoft.SQLServer.2017.Linux.Agent | False |
| MSSQL 2017 on Linux: Discover Memory-Optimized Data Filegroup Containers | Microsoft.SQLServer.2017.Linux.Discovery.Container | Microsoft.SQLServer.2017.Linux.DBFilegroupFx | True |
| MSSQL 2017 on Linux: Discover SQL Server 2017 Databases for a Database Engine | Microsoft.SQLServer.2017.Linux.Discovery.Database | Microsoft.SQLServer.2017.Linux.DBEngine | True |
| MSSQL 2017 on Linux: Discover Database Engine Resource Pool managing Memory-Optimized Data resources | Microsoft.SQLServer.2017.Linux.Discovery.DatabaseResourcePool | Microsoft.SQLServer.2017.Linux.Database | True |
| MSSQL 2017 on Linux: Discover Database Custom User Policy | Microsoft.SQLServer.2017.Linux.Discovery.DatabaseUserPolicy | Microsoft.SQLServer.2017.Linux.Database | False |
| MSSQL 2017 on Linux: Discover SQL Server 2017 Database Engines | Microsoft.SQLServer.2017.Linux.Discovery.DBEngine | Microsoft.SQLServer.2017.Linux.DBEngineSeed | True |
| MSSQL 2017 on Linux: DB Engine Express Group Discovery | Microsoft.SQLServer.2017.Linux.Discovery.DBEngineExpressGroup | Microsoft.SQLServer.2017.Linux.DBEngineExpressGroup | True |
| MSSQL 2017 on Linux: DB Engine Group Discovery | Microsoft.SQLServer.2017.Linux.Discovery.DBEngineGroup | Microsoft.SQLServer.2017.Linux.DBEngineGroup | True |
| MSSQL 2017 on Linux: Discover SQL Server 2017 DB Files | Microsoft.SQLServer.2017.Linux.Discovery.DBFile | Microsoft.SQLServer.2017.Linux.DBFilegroup | True |
| MSSQL 2017 on Linux: Discover SQL Server 2017 DB Filegroups | Microsoft.SQLServer.2017.Linux.Discovery.DBFilegroup | Microsoft.SQLServer.2017.Linux.Database | True |
| MSSQL 2017 on Linux: Discover FILESTREAM Filegroups | Microsoft.SQLServer.2017.Linux.Discovery.DBFilegroupFd | Microsoft.SQLServer.2017.Linux.Database | True |
| MSSQL 2017 on Linux: Discover Memory-Optimized Data Filegroup | Microsoft.SQLServer.2017.Linux.Discovery.DBFilegroupFx | Microsoft.SQLServer.2017.Linux.Database | True |
| MSSQL 2017 on Linux: Discover SQL Server 2017 Transaction Log File | Microsoft.SQLServer.2017.Linux.Discovery.DBLogFile | Microsoft.SQLServer.2017.Linux.Database | True |
| MSSQL 2017 on Linux: Discover SQL Server 2017 Monitoring Pool Alert Collections | Microsoft.SQLServer.2017.Linux.Discovery.MonitoringPoolAlertCollection | Microsoft.SystemCenter.AllManagementServersPool | True |
| MSSQL 2017 on Linux: Discover Database Engine Resource Pools | Microsoft.SQLServer.2017.Linux.Discovery.ResourcePool | Microsoft.SQLServer.2017.Linux.DBEngine | True |
| DisplayName | ID | Target | Category | Enabled | Alert Generate | |
|---|---|---|---|---|---|---|
 | MSSQL 2017 on Linux: Discovery Error | Microsoft.SQLServer.2017.Linux.Rule.MonitoringPoolAlertCollection.DiscoveryError | Microsoft.SQLServer.2017.Linux.MonitoringPoolAlertCollection | Alert | True | True |
| MSSQL 2017 on Linux: Discovery Warning | Microsoft.SQLServer.2017.Linux.Rule.MonitoringPoolAlertCollection.DiscoveryWarning | Microsoft.SQLServer.2017.Linux.MonitoringPoolAlertCollection | Alert | True | True |
| DisplayName | ID | ImageID | |
|---|---|---|---|
 | MSSQL 2017 on Linux: DB Memory-Optimized Data Container | Microsoft.SQLServer.2017.Linux.Container | Microsoft.SQLServer.2017.Library.Icons.Container.Image64 |
| MSSQL 2017 on Linux: DB Memory-Optimized Data Filegroup | Microsoft.SQLServer.2017.Linux.DBFilegroupFx | Microsoft.SQLServer.2017.Library.Icon.DBFilegroupFx.Image64 |
| ID | File Name | Accessibility | |
|---|---|---|---|
 | Microsoft.SQLServer.2017.Linux.Module.Discovery.Assembly | Microsoft.SQLServer.2017.Linux.Module.Discovery.dll | Public |
| Microsoft.SQLServer.2017.Module.Helper.Assembly | Microsoft.SQLServer.2017.Module.Helper.dll | Public |
Home
Show Management Pack References