This Management Pack discovers Microsoft SQL Server 2017 and related objects on Windows. 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 Windows (Discovery) Management Pack discovers Microsoft SQL Server 2017 and related objects on Windows. 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 Windows: Agent | Microsoft.SQLServer.2017.Windows.Agent | Microsoft.SQLServer.2017.Library.Agent | False | True | False | False | False | Public |
 | MSSQL 2017 on Windows: Agent Job | Microsoft.SQLServer.2017.Windows.AgentJob | Microsoft.SQLServer.2017.Library.AgentJob | False | True | False | False | False | Public |
 | MSSQL 2017 on Windows: DB Memory-Optimized Data Container | Microsoft.SQLServer.2017.Windows.Container | Microsoft.SQLServer.2017.Library.Container | False | True | False | False | False | Public |
 | MSSQL 2017 on Windows: Database | Microsoft.SQLServer.2017.Windows.Database | Microsoft.SQLServer.2017.Library.Database | False | True | False | False | False | Public |
 | MSSQL 2017 on Windows: Database Critical Policy | Microsoft.SQLServer.2017.Windows.DatabaseErrorUserPolicy | Microsoft.SQLServer.2017.Windows.Policy | False | True | False | False | False | Public |
| MSSQL 2017 on Windows: Database Warning Policy | Microsoft.SQLServer.2017.Windows.DatabaseWarningUserPolicy | Microsoft.SQLServer.2017.Windows.Policy | False | True | False | False | False | Public |
 | MSSQL 2017 on Windows: DB Engine | Microsoft.SQLServer.2017.Windows.DBEngine | Microsoft.SQLServer.2017.Library.DBEngine | False | False | False | False | False | Public |
 | MSSQL 2017 on Windows: DB Engine Express Group | Microsoft.SQLServer.2017.Windows.DBEngineExpressGroup | System.Group | False | False | True | True | False | Public |
| MSSQL 2017 on Windows: DB Engine Group | Microsoft.SQLServer.2017.Windows.DBEngineGroup | System.Group | False | False | True | True | False | Public |
 | MSSQL 2017 on Windows: DB Engine Seed | Microsoft.SQLServer.2017.Windows.DBEngineSeed | System.Entity | False | False | False | False | False | Public |
 | MSSQL 2017 on Windows: DB File | Microsoft.SQLServer.2017.Windows.DBFile | Microsoft.SQLServer.2017.Library.DBFile | False | True | False | False | False | Public |
 | MSSQL 2017 on Windows: DB Filegroup | Microsoft.SQLServer.2017.Windows.DBFilegroup | Microsoft.SQLServer.2017.Library.DBFilegroup | False | True | False | False | False | Public |
| MSSQL 2017 on Windows: DB FILESTREAM Filegroup | Microsoft.SQLServer.2017.Windows.DBFilegroupFd | Microsoft.SQLServer.2017.Library.DBFilegroupFd | False | True | False | False | False | Public |
 | MSSQL 2017 on Windows: DB Memory-Optimized Data Filegroup | Microsoft.SQLServer.2017.Windows.DBFilegroupFx | Microsoft.SQLServer.2017.Library.DBFilegroupFx | False | True | False | False | False | Public |
 | MSSQL 2017 on Windows: DB Log File | Microsoft.SQLServer.2017.Windows.DBLogFile | Microsoft.SQLServer.2017.Library.DBLogFile | False | True | False | False | False | Public |
 | MSSQL 2017 on Windows: Default Resource Pool | Microsoft.SQLServer.2017.Windows.DefaultPool | Microsoft.SQLServer.2017.Windows.UserResourcePool | False | True | False | False | False | Public |
| MSSQL 2017 on Windows: Internal Resource Pool | Microsoft.SQLServer.2017.Windows.InternalPool | Microsoft.SQLServer.2017.Windows.ResourcePool | False | True | False | False | False | Public |
| MSSQL 2017 on Windows: Local Agent | Microsoft.SQLServer.2017.Windows.LocalAgent | Microsoft.SQLServer.2017.Windows.Agent | False | True | False | False | False | Public |
| MSSQL 2017 on Windows: Local Agent Job | Microsoft.SQLServer.2017.Windows.LocalAgentJob | Microsoft.SQLServer.2017.Windows.AgentJob | False | True | False | False | False | Public |
| MSSQL 2017 on Windows: Local DB | Microsoft.SQLServer.2017.Windows.LocalDatabase | Microsoft.SQLServer.2017.Windows.Database | False | True | False | False | False | Public |
| MSSQL 2017 on Windows: Local DB Engine | Microsoft.SQLServer.2017.Windows.LocalDBEngine | Microsoft.SQLServer.2017.Windows.DBEngine | False | False | False | False | False | Public |
 | MSSQL 2017 on Windows: Local Discovery Seed | Microsoft.SQLServer.2017.Windows.LocalDiscoverySeed | Microsoft.Windows.ApplicationComponent | False | True | False | False | False | Public |
| MSSQL 2017 on Windows: Monitoring Pool Alert Collection | Microsoft.SQLServer.2017.Windows.MonitoringPoolAlertCollection | Microsoft.SQLServer.2017.Library.MonitoringPoolAlertCollection | False | True | False | False | False | Public |
| MSSQL 2017 on Windows: Custom User Policy | Microsoft.SQLServer.2017.Windows.Policy | Microsoft.SQLServer.2017.Library.Policy | True | False | False | False | False | Public |
| MSSQL 2017 on Windows: Resource Pool | Microsoft.SQLServer.2017.Windows.ResourcePool | Microsoft.SQLServer.2017.Library.ResourcePool | True | True | False | False | False | Public |
| MSSQL 2017 on Windows: Resource Pool Group | Microsoft.SQLServer.2017.Windows.ResourcePoolGroup | System.Entity | False | True | False | False | False | Public |
| MSSQL 2017 on Windows: User-Defined Resource Pool | Microsoft.SQLServer.2017.Windows.UserDefinedPool | Microsoft.SQLServer.2017.Windows.UserResourcePool | False | True | False | False | False | Public |
| MSSQL 2017 on Windows: User Resource Pool | Microsoft.SQLServer.2017.Windows.UserResourcePool | Microsoft.SQLServer.2017.Windows.ResourcePool | True | True | False | False | False | Public |
| DisplayName | ID | Source | Target | Accessibility | Abstract | |
|---|---|---|---|---|---|---|
 | MSSQL 2017 on Windows: Agent Hosts SQL Server 2017 Agent Job | Microsoft.SQLServer.2017.Windows.AgentHostsAgentJob | Microsoft.SQLServer.2017.Windows.Agent | Microsoft.SQLServer.2017.Windows.AgentJob | Public | False |
| MSSQL 2017 on Windows: DB Hosts SQL Server 2017 Database Critical Policy | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBErrorUserPolicy | Microsoft.SQLServer.2017.Windows.Database | Microsoft.SQLServer.2017.Windows.DatabaseErrorUserPolicy | Public | False |
| MSSQL 2017 on Windows: DB Hosts SQL Server 2017 DB Filegroup | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBFilegroup | Microsoft.SQLServer.2017.Windows.Database | Microsoft.SQLServer.2017.Windows.DBFilegroup | Public | False |
| MSSQL 2017 on Windows: DB Hosts SQL Server 2017 DB FILESTREAM Filegroup | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBFilegroupFd | Microsoft.SQLServer.2017.Windows.Database | Microsoft.SQLServer.2017.Windows.DBFilegroupFd | Public | False |
| MSSQL 2017 on Windows: DB Hosts SQL Server 2017 DB Memory-Optimized Data Filegroup | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBFilegroupFx | Microsoft.SQLServer.2017.Windows.Database | Microsoft.SQLServer.2017.Windows.DBFilegroupFx | Public | False |
| MSSQL 2017 on Windows: DB Hosts SQL Server 2017 DB Log File | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBLogFile | Microsoft.SQLServer.2017.Windows.Database | Microsoft.SQLServer.2017.Windows.DBLogFile | Public | False |
| MSSQL 2017 on Windows: DB Hosts SQL Server 2017 Database Warning Policy | Microsoft.SQLServer.2017.Windows.DatabaseHostsDBWarningUserPolicy | Microsoft.SQLServer.2017.Windows.Database | Microsoft.SQLServer.2017.Windows.DatabaseWarningUserPolicy | Public | False |
| MSSQL 2017 on Windows: Database References User Resource Pool | Microsoft.SQLServer.2017.Windows.DatabaseReferencesUserResourcePool | Microsoft.SQLServer.2017.Windows.Database | Microsoft.SQLServer.2017.Windows.UserResourcePool | Public | False |
| MSSQL 2017 on Windows: DB Engine Express Group Contains SQL Server 2017 DB Engine | Microsoft.SQLServer.2017.Windows.DBEngineExpressGroupContainsDBEngine | Microsoft.SQLServer.2017.Windows.DBEngineExpressGroup | Microsoft.SQLServer.2017.Windows.DBEngine | Public | False |
| MSSQL 2017 on Windows: DB Engine Group Contains SQL Server 2017 DB Engine | Microsoft.SQLServer.2017.Windows.DBEngineGroupContainsDBEngine | Microsoft.SQLServer.2017.Windows.DBEngineGroup | Microsoft.SQLServer.2017.Windows.DBEngine | Public | False |
| MSSQL 2017 on Windows: DB Engine Hosts SQL Server 2017 Agent | Microsoft.SQLServer.2017.Windows.DBEngineHostsAgent | Microsoft.SQLServer.2017.Windows.DBEngine | Microsoft.SQLServer.2017.Windows.Agent | Public | False |
| MSSQL 2017 on Windows: DB Engine Hosts SQL Server 2017 DB | Microsoft.SQLServer.2017.Windows.DBEngineHostsDatabase | Microsoft.SQLServer.2017.Windows.DBEngine | Microsoft.SQLServer.2017.Windows.Database | Public | False |
| MSSQL 2017 on Windows: DB Engine Hosts SQL Server 2017 Resource Pool Group | Microsoft.SQLServer.2017.Windows.DBEngineHostsResourcePoolGroup | Microsoft.SQLServer.2017.Windows.DBEngine | Microsoft.SQLServer.2017.Windows.ResourcePoolGroup | Public | False |
| MSSQL 2017 on Windows: DB Engine Seed Contains SQL Server 2017 DB Engine | Microsoft.SQLServer.2017.Windows.DBEngineSeedContainsDBEngine | Microsoft.SQLServer.2017.Windows.DBEngineSeed | Microsoft.SQLServer.2017.Windows.DBEngine | Public | False |
| MSSQL 2017 on Windows: DB Filegroup Hosts SQL Server 2017 DB Memory-Optimized Data Container | Microsoft.SQLServer.2017.Windows.DBFilegroupFxHostsContainer | Microsoft.SQLServer.2017.Windows.DBFilegroupFx | Microsoft.SQLServer.2017.Windows.Container | Public | False |
| MSSQL 2017 on Windows: DB Filegroup Hosts SQL Server 2017 DB File | Microsoft.SQLServer.2017.Windows.DBFilegroupHostsDBFile | Microsoft.SQLServer.2017.Windows.DBFilegroup | Microsoft.SQLServer.2017.Windows.DBFile | Public | False |
| MSSQL 2017 on Windows: Resource Pool Group Hosts SQL Server 2017 Resource Pool | Microsoft.SQLServer.2017.Windows.ResourcePoolGroupHostsResourcePool | Microsoft.SQLServer.2017.Windows.ResourcePoolGroup | Microsoft.SQLServer.2017.Windows.ResourcePool | Public | False |
| MSSQL 2017 on Windows: Server Computer Contains SQL Server 2017 DB Engine | Microsoft.SQLServer.2017.Windows.ServerComputerContainsDBEngine | Microsoft.Windows.Server.Computer | Microsoft.SQLServer.2017.Windows.DBEngine | Public | False |
| MSSQL 2017 on Windows: Server Computer Hosts SQL Server 2017 Local Discovery Seed | Microsoft.SQLServer.2017.Windows.ServerComputerHostsLocalDiscoverySeed | Microsoft.Windows.Server.Computer | Microsoft.SQLServer.2017.Windows.LocalDiscoverySeed | Public | False |
| ID | Isolation | Accessibility | |
|---|---|---|---|
 | Microsoft.SQLServer.2017.Windows.ConditionDetection.DatabaseResourcePoolDataMapper | Any | Public |
| Microsoft.SQLServer.2017.Windows.ConditionDetection.ResourcePoolDiscoveryFilter | Any | Internal |
| Microsoft.SQLServer.2017.Windows.Discovery.DiscoveryDataMapper | Any | Public |
| DisplayName | ID | Isolation | Accessibility | |
|---|---|---|---|---|
 | MSSQL 2017 on Windows: Agent Discovery Data Source | Microsoft.SQLServer.2017.Windows.DataSource.AgentDiscovery | Any | Internal |
| MSSQL 2017 on Windows: Agent Job Discovery Data Source | Microsoft.SQLServer.2017.Windows.DataSource.AgentJobDiscovery | Any | Internal |
| MSSQL 2017 on Windows: Container Discovery Data Source | Microsoft.SQLServer.2017.Windows.DataSource.ContainerDiscovery | Any | Internal |
| MSSQL 2017 on Windows: Database Discovery Data Source | Microsoft.SQLServer.2017.Windows.DataSource.DatabaseDiscovery | Any | Internal |
| MSSQL 2017 on Windows: Data Source Database Memory-Optimized Data Resource Pools on Windows | Microsoft.SQLServer.2017.Windows.DataSource.DatabaseResourcePool | Any | Internal |
| MSSQL 2017 on Windows: Custom User Policy Discovery Data Source | Microsoft.SQLServer.2017.Windows.DataSource.DatabaseUserPolicyDiscovery | Any | Internal |
| MSSQL 2017 on Windows: Custom User Policy DiscoveryCD Data Source | Microsoft.SQLServer.2017.Windows.DataSource.DatabaseUserPolicyDiscoveryProbe | Any | Internal |
| MSSQL 2017 on Windows: DB Engine Discovery Data Source | Microsoft.SQLServer.2017.Windows.DataSource.DBEngineDiscovery | Any | Public |
| MSSQL 2017 on Windows: DB File Discovery Data Source | Microsoft.SQLServer.2017.Windows.DataSource.DBFileDiscovery | Any | Internal |
| MSSQL 2017 on Windows: DB File Discovery Data Source on Windows | Microsoft.SQLServer.2017.Windows.DataSource.DBFileDiscoveryProbe | Any | Internal |
| MSSQL 2017 on Windows: DB Filegroup Discovery Data Source on Windows | Microsoft.SQLServer.2017.Windows.DataSource.DBFilegroupDiscovery | Any | Internal |
| MSSQL 2017 on Windows: DB Filegroup DiscoveryCD Data Source | Microsoft.SQLServer.2017.Windows.DataSource.DBFilegroupDiscoveryProbe | Any | Internal |
| MSSQL 2017 on Windows: DB FILESTREAM Filegroup Discovery Data Source | Microsoft.SQLServer.2017.Windows.DataSource.DBFilegroupFdDiscovery | Any | Internal |
| MSSQL 2017 on Windows: Memory-Optimized Data Filegroup Discovery Data Source | Microsoft.SQLServer.2017.Windows.DataSource.DBFilegroupFxDiscovery | Any | Internal |
| MSSQL 2017 on Windows: Transaction Log File Discovery Data Source | Microsoft.SQLServer.2017.Windows.DataSource.DBLogFileDiscovery | Any | Internal |
| MSSQL 2017 on Windows: Data Source for Local Alert Collection Target Discovery | Microsoft.SQLServer.2017.Windows.DataSource.LocalAlertCollectionDiscovery | Any | Public |
| MSSQL 2017 on Windows: Local SQL Server 2017 Database Engines Discovery Source | Microsoft.SQLServer.2017.Windows.DataSource.LocalDBEngineDiscovery | Any | Internal |
| MSSQL 2017 on Windows: Data Source Database Engine Resource Pools on Windows | Microsoft.SQLServer.2017.Windows.DataSource.ResourcePool | Any | Internal |
| MSSQL 2017 on Windows: Data Source Database Engine Resource Pools on Windows | Microsoft.SQLServer.2017.Windows.DataSource.ResourcePoolProbe | Any | Internal |
| DisplayName | ID | Isolation | Accessibility | |
|---|---|---|---|---|
 | MSSQL 2017 on Windows: Agent Probe Discovery | Microsoft.SQLServer.2017.Windows.ProbeAction.AgentDiscovery | Any | Internal |
| MSSQL 2017 on Windows: Agent Job Probe Discovery | Microsoft.SQLServer.2017.Windows.ProbeAction.AgentJobDiscovery | Any | Internal |
| MSSQL 2017 on Windows: Database Probe Discovery | Microsoft.SQLServer.2017.Windows.ProbeAction.DatabaseDiscovery | Any | Internal |
| MSSQL 2017 on Windows: Custom User Policy Probe DiscoveryCD | Microsoft.SQLServer.2017.Windows.ProbeAction.DatabaseUserPolicyDiscoveryCD | Any | Internal |
| MSSQL 2017 on Windows: DB Engine Probe Discovery | Microsoft.SQLServer.2017.Windows.ProbeAction.DBEngineDiscovery | Any | Internal |
| MSSQL 2017 on Windows: File Probe DiscoveryCD | Microsoft.SQLServer.2017.Windows.ProbeAction.FileDiscoveryCD | Any | Internal |
| MSSQL 2017 on Windows: Filegroup Probe DiscoveryCD | Microsoft.SQLServer.2017.Windows.ProbeAction.FilegroupDiscoveryCD | Any | Internal |
| MSSQL 2017 on Windows: Local DB Engine Probe Discovery on Windows | Microsoft.SQLServer.2017.Windows.ProbeAction.LocalDBEngineDiscovery | Any | Internal |
| MSSQL 2017 on Windows: ResourcePool Probe on Windows | Microsoft.SQLServer.2017.Windows.ProbeAction.ResourcePool | Any | Internal |
| ID | Accessibility | |
|---|---|---|
 | Microsoft.SQLServer.2017.Windows.Discovery.DiscoveryDataMapperSchema | Public |
| DisplayName | ID | Target | Enabled | |
|---|---|---|---|---|
 | MSSQL 2017 on Windows: Discover SQL Server 2017 Agent for a Database Engine | Microsoft.SQLServer.2017.Windows.Discovery.Agent | Microsoft.SQLServer.2017.Windows.DBEngine | True |
| MSSQL 2017 on Windows: Discover SQL Server 2017 Agent Jobs | Microsoft.SQLServer.2017.Windows.Discovery.AgentJob | Microsoft.SQLServer.2017.Windows.Agent | False |
| MSSQL 2017 on Windows: Discover Memory-Optimized Data Filegroup Containers | Microsoft.SQLServer.2017.Windows.Discovery.Container | Microsoft.SQLServer.2017.Windows.DBFilegroupFx | True |
| MSSQL 2017 on Windows: Discover SQL Server 2017 Databases for a Database Engine | Microsoft.SQLServer.2017.Windows.Discovery.Database | Microsoft.SQLServer.2017.Windows.DBEngine | True |
| MSSQL 2017 on Windows: Discover Database Engine Resource Pool managing Memory-Optimized Data resources | Microsoft.SQLServer.2017.Windows.Discovery.DatabaseResourcePool | Microsoft.SQLServer.2017.Windows.Database | True |
| MSSQL 2017 on Windows: Discover Database Custom User Policy | Microsoft.SQLServer.2017.Windows.Discovery.DatabaseUserPolicy | Microsoft.SQLServer.2017.Windows.Database | False |
| MSSQL 2017 on Windows: Discover SQL Server 2017 Database Engines | Microsoft.SQLServer.2017.Windows.Discovery.DBEngine | Microsoft.SQLServer.2017.Windows.DBEngineSeed | True |
| MSSQL 2017 on Windows: DB Engine Express Group Discovery | Microsoft.SQLServer.2017.Windows.Discovery.DBEngineExpressGroup | Microsoft.SQLServer.2017.Windows.DBEngineExpressGroup | True |
| MSSQL 2017 on Windows: DB Engine Group Discovery | Microsoft.SQLServer.2017.Windows.Discovery.DBEngineGroup | Microsoft.SQLServer.2017.Windows.DBEngineGroup | True |
| MSSQL 2017 on Windows: Discover SQL Server 2017 DB Files | Microsoft.SQLServer.2017.Windows.Discovery.DBFile | Microsoft.SQLServer.2017.Windows.DBFilegroup | True |
| MSSQL 2017 on Windows: Discover SQL Server 2017 DB Filegroups | Microsoft.SQLServer.2017.Windows.Discovery.DBFilegroup | Microsoft.SQLServer.2017.Windows.Database | True |
| MSSQL 2017 on Windows: Discover FILESTREAM Filegroups | Microsoft.SQLServer.2017.Windows.Discovery.DBFilegroupFd | Microsoft.SQLServer.2017.Windows.Database | True |
| MSSQL 2017 on Windows: Discover Memory-Optimized Data Filegroup | Microsoft.SQLServer.2017.Windows.Discovery.DBFilegroupFx | Microsoft.SQLServer.2017.Windows.Database | True |
| MSSQL 2017 on Windows: Discover SQL Server 2017 Transaction Log File | Microsoft.SQLServer.2017.Windows.Discovery.DBLogFile | Microsoft.SQLServer.2017.Windows.Database | True |
| MSSQL 2017 on Windows: Discover Installation Source (seed) | Microsoft.SQLServer.2017.Windows.Discovery.LocalDiscoverySeed | Microsoft.Windows.Server.Computer | True |
| MSSQL 2017 on Windows: Discover Monitoring Pool Alert Collections | Microsoft.SQLServer.2017.Windows.Discovery.MonitoringPoolAlertCollection | Microsoft.SystemCenter.AllManagementServersPool | True |
| MSSQL 2017 on Windows: Discover Database Engine Resource Pools | Microsoft.SQLServer.2017.Windows.Discovery.ResourcePool | Microsoft.SQLServer.2017.Windows.DBEngine | True |
| MSSQL 2017 on Windows: Discover Local Alert Collections | Microsoft.SQLServer.2017.Windows.LocalAlertCollectionDiscovery | Microsoft.SQLServer.2017.Windows.LocalDiscoverySeed | True |
| MSSQL 2017 on Windows: Discover Local SQL Server 2017 Database Engines | Microsoft.SQLServer.2017.Windows.LocalDBEngineDiscovery | Microsoft.SQLServer.2017.Windows.LocalDiscoverySeed | True |
| DisplayName | ID | Target | Category | Enabled | Alert Generate | |
|---|---|---|---|---|---|---|
 | MSSQL 2017 on Windows: Discovery error | Microsoft.SQLServer.2017.Windows.Rule.MonitoringPoolAlertCollection.DiscoveryError | Microsoft.SQLServer.2017.Windows.MonitoringPoolAlertCollection | Alert | True | True |
| MSSQL 2017 on Windows: Discovery warning | Microsoft.SQLServer.2017.Windows.Rule.MonitoringPoolAlertCollection.DiscoveryWarning | Microsoft.SQLServer.2017.Windows.MonitoringPoolAlertCollection | Alert | True | True |
| DisplayName | ID | ImageID | |
|---|---|---|---|
 | MSSQL 2017 on Windows: DB Memory-Optimized Data Container | Microsoft.SQLServer.2017.Windows.Container | Microsoft.SQLServer.2017.Library.Icons.Container.Image64 |
| MSSQL 2017 on Windows: DB Memory-Optimized Data Filegroup | Microsoft.SQLServer.2017.Windows.DBFilegroupFx | Microsoft.SQLServer.2017.Library.Icon.DBFilegroupFx.Image64 |
| ID | File Name | Accessibility | |
|---|---|---|---|
 | Microsoft.SQLServer.2017.Module.Helper.Assembly | Microsoft.SQLServer.2017.Module.Helper.dll | Public |
| Microsoft.SQLServer.2017.Windows.Module.Discovery.Assembly | Microsoft.SQLServer.2017.Windows.Module.Discovery.dll | Public |
Home
Show Management Pack References