| | DisplayName | Description | ID | RunAs | Accessibility | Support Monitor Recalculate |
|---|
 | MSSQL 2016: Agent Job Last Run State Provider | | Microsoft.SQLServer.2016.AgentJobLastRunProvider | | Internal | False |
| MSSQL 2016: Agent Long Running Jobs | This monitor type checks the current execution time of all agent jobs against specified time thresholds. | Microsoft.SQLServer.2016.AgentLongRunningJobsProvider | | Internal | False |
| MSSQL 2016: Agent Long Running Jobs Provider (Per Job) | | Microsoft.SQLServer.2016.AgentLongRunningJobsProviderPerJob | | Internal | False |
| MSSQL 2016: Server Windows Service (Database) | Monitor type for detect state of SQL Server windows service from database objects. | Microsoft.SQLServer.2016.CheckDBEngineServiceStateMonitorType | Microsoft.SQLServer.MonitoringAccount | Internal | False |
| MSSQL 2016: Server Windows Service | Monitor type for detect state of SQL Server windows service. | Microsoft.SQLServer.2016.CheckWinServiceStateMonitorType | Microsoft.SQLServer.MonitoringAccount | Internal | False |
| MSSQL 2016: DB Disk Read Latency monitor type | DB Disk Read Latency monitor type for 2016 DBs | Microsoft.SQLServer.2016.Database.DiskReadLatency.MonitorType | Microsoft.SQLServer.MonitoringAccount | Internal | False |
| MSSQL 2016: DB Disk Write Latency monitor type | DB Disk Write Latency monitor type for 2016 DBs | Microsoft.SQLServer.2016.Database.DiskWriteLatency.MonitorType | Microsoft.SQLServer.MonitoringAccount | Internal | False |
| MSSQL 2016: DB Transaction Log Free Space (\%) performance monitor type | Transaction Log Free Space (\%) monitor type for 2016 DBs | Microsoft.SQLServer.2016.Database.TransactionLogSpaceFreePercent.MonitorType | Microsoft.SQLServer.MonitoringAccount | Internal | False |
| MSSQL 2016: Database / Log Free Space | This monitor type checks the amount of free space of the database or the log file on Microsoft SQL Server 2016 Database against the specified thresholds. The monitor type can check for absolute free space, or free space expressed as percentage. | Microsoft.SQLServer.2016.DBAndLogSizeMonitorType | | Internal | False |
| MSSQL 2016: Database Backup Status | This monitor type checks the state of a database backup on a Microsoft SQL Server 2016 Database Engine installation. | Microsoft.SQLServer.2016.DBBackupStatus | | Internal | False |
| MSSQL 2016: Database Configuration Check | This monitor type checks a known database configuration value against a specified expected value. | Microsoft.SQLServer.2016.DBConfigurationStatus | | Internal | False |
| MSSQL 2016: DB Average Wait Time performance monitor type | Average Wait Time monitor type for 2016 DBs | Microsoft.SQLServer.2016.DBEngine.AverageWaitTime.MonitorType | Microsoft.SQLServer.MonitoringAccount | Internal | False |
| MSSQL 2016: Blocked Session Provider | | Microsoft.SQLServer.2016.DBEngine.BlockedSPIDs | | Internal | False |
| MSSQL 2016: DB Engine Buffer Cache Hit Ratio monitor type | DB Engine Buffer Cache Hit Ratio monitor type for 2016 DBs | Microsoft.SQLServer.2016.DBEngine.BufferCacheHitRatio.MonitorType | Microsoft.SQLServer.MonitoringAccount | Internal | False |
| MSSQL 2016: SPN Configuration Status | This monitor type checks the state of a Microsoft SQL Server 2016 Database Engine SPN configuration. | Microsoft.SQLServer.2016.DBEngine.Configuration.SPNStatus | Microsoft.SQLServer.MonitoringAccount | Internal | False |
| MSSQL 2016: DB Engine CPU Utilization (\%) monitor type | DB Engine CPU Utilization (\%) monitor type for 2016 DBs | Microsoft.SQLServer.2016.DBEngine.CPUUsagePercent.MonitorType | Microsoft.SQLServer.MonitoringAccount | Internal | False |
| MSSQL 2016: DB Engine Page Life Expectancy (s) monitor type | DB Engine Page Life Expectancy (s) monitor type for 2016 DBs | Microsoft.SQLServer.2016.DBEngine.PageLifeExpectancy.MonitorType | Microsoft.SQLServer.MonitoringAccount | Internal | False |
| MSSQL 2016: SQL Re-Compilation monitor type | DB Engine SQL Re-Compilation monitor type | Microsoft.SQLServer.2016.DBEngine.SQLReCompilation.MonitorType | Microsoft.SQLServer.MonitoringAccount | Internal | False |
| MSSQL 2016: DB Engine Stolen Server Memory monitor type | DB Engine Stolen Server Memory monitor type for 2016 DBs | Microsoft.SQLServer.2016.DBEngine.StolenServerMemory.MonitorType | Microsoft.SQLServer.MonitoringAccount | Internal | False |
| MSSQL 2016: DB Engine Thread Count monitor type | DB Engine Thread Count monitor type for 2016 DBs | Microsoft.SQLServer.2016.DBEngine.ThreadCount.MonitorType | Microsoft.SQLServer.MonitoringAccount | Internal | False |
| MSSQL 2016: Memory-Optimized Data Stale Checkpoint Files Ratio Monitor Type | SQL Server 2016 Memory-Optimized Data Stale Checkpoint Files Ratio Monitor Type | Microsoft.SQLServer.2016.DBFileGroupFx.StaleCFPs.MonitorType | | Internal | False |
| MSSQL 2016: DB File Free Space Total | | Microsoft.SQLServer.2016.DBFileSizeMonitorType | | Internal | False |
| MSSQL 2016: DB Log File Free Space Total | | Microsoft.SQLServer.2016.DBLogFileSizeMonitorType | | Internal | False |
| MSSQL 2016: DB Percentage Change | This monitor type checks for a change in database free space between subsequent polling intervals. | Microsoft.SQLServer.2016.DBPercentageChange | | Internal | False |
| MSSQL 2016: Database Status | This monitor type checks the state of a database on a Microsoft SQL Server 2016 Database Engine installation. | Microsoft.SQLServer.2016.DBStatus | | Internal | False |
| MSSQL 2016: Average length of the row chains in the hash buckets monitor type | Average length of the row chains in the hash buckets monitor type | Microsoft.SQLServer.2016.Monitoring.HashIndexAvgChainLength.MonitorType | Microsoft.SQLServer.MonitoringAccount | Internal | False |
| MSSQL 2016: Empty Bucket percent in the hash index monitor type | Empty Bucket percent in the hash index monitor type | Microsoft.SQLServer.2016.Monitoring.HashIndexEmptyBucketsCount.MonitorType | Microsoft.SQLServer.MonitoringAccount | Internal | False |
| MSSQL 2016: XTP Configuration monitor type | XTP Configuration monitor type | Microsoft.SQLServer.2016.Monitoring.XTPConfiguration.MonitorType | Microsoft.SQLServer.MonitoringAccount | Internal | False |
| MSSQL 2016: Memory-Optimized Data Filegroup Container Space Monitor Type | SQL Server 2016 Memory-Optimized Data Filegroup Container Space Monitor Type | Microsoft.SQLServer.2016.MonitorType.Container.FreeSpacePercent | | Internal | False |
| MSSQL 2016: Smart Admin Health Policy Monitor Type | Two state monitor type used to monitor Smart Admin Health Policies. | Microsoft.SQLServer.2016.MonitorType.DBEngine.SmartAdminHealthPolicy | | Internal | False |
| [Deprecated] MSSQL 2016: Garbage Collection State Monitor Type | Garbage Collection State monitor type for 2016 Memory-Optimized Data checks fill factor metrics.
This monitor type is considered to be obsolete in this Management Pack. | Microsoft.SQLServer.2016.MonitorType.DBFileGroupFx.GarbageCollectionState | | Internal | False |
| MSSQL 2016: Memory-Optimized Data User Resource Pool Monitor Type | SQL Server 2016 Memory-Optimized Data User Resource Pool Monitor Type | Microsoft.SQLServer.2016.MonitorType.UserResourcePool.MemoryConsumption | | Internal | False |
| MSSQL 2016: Service Pack Check | This monitor type checks the current service pack is greater than or equal the specified value. | Microsoft.SQLServer.2016.ServicePackVersion | Microsoft.SQLServer.MonitoringAccount | Internal | False |
| MSSQL 2016: Two State Policy Monitor Type | Two state monitor type used to monitor Custom User Policies. | Microsoft.SQLServer.2016.TwoStatePolicyMonitorType | | Internal | False |
| Microsoft.SQLServer.2016.DBFileStreamGroupSizeMonitorType | | Microsoft.SQLServer.2016.DBFileStreamGroupSizeMonitorType | | Internal | False |
Home