All Unit Monitors in Microsoft.SQLServer.2012.Monitoring Management Pack

 DisplayNameDescriptionIDTargetParent MonitorCategoryEnabledInstance NameCounter NameFrequencyAlert GenerateAlert SeverityAlert PriorityAlert Auto ResolveMonitor TypeRemotableAccessibilityRunAs
Microsoft.SQLServer.2012.Agent.LongRunningJobs长时间运行的作业此监视器检查长期运行的 SQL 代理作业。 请注意,任何版本的 SQL Server Express 均不支持 SQL Server 代理 Windows 服务,没有合适的发现对象。此监视器在默认情况下为禁用。请在必要时使用替代启用该监视器。Microsoft.SQLServer.2012.Agent.LongRunningJobsMicrosoft.SQLServer.2012.AgentSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2012.AgentLongRunningJobsProviderTruePublic
Microsoft.SQLServer.2012.Agent.ServiceMonitorSQL Server 代理 Windows 服务此监视器检查此 SQL Server 实例的 SQL 代理服务的状态。 请注意,任何版本的 SQL Server Express 均不支持 SQL Server 代理 Windows 服务。Microsoft.SQLServer.2012.Agent.ServiceMonitorMicrosoft.SQLServer.2012.AgentSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2012.AgentJob.JobDuration作业周期监视代理作业周期。 请注意,任何版本的 SQL Server Express 均不支持 SQL Server 代理 Windows 服务,没有合适的发现对象。Microsoft.SQLServer.2012.AgentJob.JobDurationMicrosoft.SQLServer.2012.AgentJobSystem.Health.PerformanceStatePerformanceCollectionTrue0FalseTrueMicrosoft.SQLServer.2012.AgentLongRunningJobsProviderPerJobTruePublic
Microsoft.SQLServer.2012.AgentJob.JobLastRunState上次运行状态SQL 2012 代理作业上次运行状态监视器。监视 SQL 代理作业上次运行的状态。 请注意,任何版本的 SQL Server Express 均不支持 SQL Server 代理 Windows 服务,没有合适的发现对象。Microsoft.SQLServer.2012.AgentJob.JobLastRunStateMicrosoft.SQLServer.2012.AgentJobSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.2012.AgentJobLastRunProviderTruePublic
Microsoft.SQLServer.2012.AnalysisServices.ServiceMonitorSQL Server Analysis Services Windows 服务此监视器检查 SQL Analysis Services 服务的状态。 请注意,任何版本的 SQL Server Express 均不支持 SQL Analysis Services 服务。Microsoft.SQLServer.2012.AnalysisServices.ServiceMonitorMicrosoft.SQLServer.2012.AnalysisServicesSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2012.Database.Configuration.AutoClose自动关闭配置监视数据库的自动关闭设置Microsoft.SQLServer.2012.Database.Configuration.AutoCloseMicrosoft.SQLServer.2012.DatabaseMicrosoft.SQLServer.2012.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2012.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2012.Database.Configuration.AutoCreateStat自动创建统计信息配置监视数据库的自动创建统计信息Microsoft.SQLServer.2012.Database.Configuration.AutoCreateStatMicrosoft.SQLServer.2012.DatabaseMicrosoft.SQLServer.2012.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2012.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2012.Database.Configuration.AutoShrink自动收缩配置监视数据库的自动收缩设置Microsoft.SQLServer.2012.Database.Configuration.AutoShrinkMicrosoft.SQLServer.2012.DatabaseMicrosoft.SQLServer.2012.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2012.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2012.Database.Configuration.AutoUpdateSet自动更新统计信息配置监视数据库的自动更新统计信息设置Microsoft.SQLServer.2012.Database.Configuration.AutoUpdateSetMicrosoft.SQLServer.2012.DatabaseMicrosoft.SQLServer.2012.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2012.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2012.Database.Configuration.AutoUpdateStatAsync自动异步更新统计信息配置监视数据库的自动异步更新统计信息设置Microsoft.SQLServer.2012.Database.Configuration.AutoUpdateStatAsyncMicrosoft.SQLServer.2012.DatabaseMicrosoft.SQLServer.2012.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2012.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2012.Database.Configuration.DBChaining数据库链接配置监视数据库的数据库链接设置Microsoft.SQLServer.2012.Database.Configuration.DBChainingMicrosoft.SQLServer.2012.DatabaseMicrosoft.SQLServer.2012.Database.ExternalAccessConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2012.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2012.Database.Configuration.RecoveryModel恢复模式配置监视数据库的恢复模式设置。Microsoft.SQLServer.2012.Database.Configuration.RecoveryModelMicrosoft.SQLServer.2012.DatabaseMicrosoft.SQLServer.2012.Database.RecoveryConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2012.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2012.Database.Configuration.TornPageDetection页验证配置监视数据库的页验证设置。Microsoft.SQLServer.2012.Database.Configuration.TornPageDetectionMicrosoft.SQLServer.2012.DatabaseMicrosoft.SQLServer.2012.Database.RecoveryConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2012.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2012.Database.Configuration.TrustWorthy可信配置监视数据库的可信设置Microsoft.SQLServer.2012.Database.Configuration.TrustWorthyMicrosoft.SQLServer.2012.DatabaseMicrosoft.SQLServer.2012.Database.ExternalAccessConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2012.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2012.Database.DBBackupStatusMonitor数据库备份状态此监视器检查 Microsoft® SQL Server™ 报告的数据库备份状态。Microsoft.SQLServer.2012.Database.DBBackupStatusMonitorMicrosoft.SQLServer.2012.DatabaseSystem.Health.AvailabilityStateAvailabilityHealthFalse0TrueErrorNormalTrueMicrosoft.SQLServer.2012.DBBackupStatusTruePublic
Microsoft.SQLServer.2012.Database.DBSizePercentageChangeMonitor数据库空间百分比更改监视在一定的采样期间数据库可用空间值的显著更改。Microsoft.SQLServer.2012.Database.DBSizePercentageChangeMonitorMicrosoft.SQLServer.2012.DatabaseMicrosoft.SQLServer.2012.Database.DBSpaceMonitorPerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2012.DBPercentageChangeTruePublic
Microsoft.SQLServer.2012.Database.DBSizePercentMonitor数据库总空间监视数据库中的可用空间以及托管数据库的介质的可用空间(以百分比表示)。请注意,此监视器不对 FILESTREAM 文件组的可用空间进行计数。Microsoft.SQLServer.2012.Database.DBSizePercentMonitorMicrosoft.SQLServer.2012.DatabaseMicrosoft.SQLServer.2012.Database.DBSpaceMonitorPerformanceHealthFalse0TrueMatchMonitorHealthHighTrueMicrosoft.SQLServer.2012.DBAndLogSizeMonitorTypeTruePublic
Microsoft.SQLServer.2012.Database.DBStatusMonitor数据库状态此监视器检查 Microsoft® SQL Server™ 报告的数据库状态。Microsoft.SQLServer.2012.Database.DBStatusMonitorMicrosoft.SQLServer.2012.DatabaseSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2012.DBStatusTruePublic
Microsoft.SQLServer.2012.Database.DiskReadLatencyMonitor磁盘读取延迟针对 2012 数据库的磁盘读取延迟监视器Microsoft.SQLServer.2012.Database.DiskReadLatencyMonitorMicrosoft.SQLServer.2012.DatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueErrorNormalTrueMicrosoft.SQLServer.2012.Database.DiskReadLatency.MonitorTypeTruePublic
Microsoft.SQLServer.2012.Database.DiskWriteLatencyMonitor磁盘写入延迟针对 2012 数据库的磁盘写入延迟监视器Microsoft.SQLServer.2012.Database.DiskWriteLatencyMonitorMicrosoft.SQLServer.2012.DatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueErrorNormalTrueMicrosoft.SQLServer.2012.Database.DiskWriteLatency.MonitorTypeTruePublic
Microsoft.SQLServer.2012.Database.LogShippingDestinationMonitor日志传送目标此监视器检测日志传送目标尚未在阈值(作为日志传送配置的一部分定义)内将日志还原到它的情况。 请注意,任何版本的 SQL Server Express 均不支持日志传送。Microsoft.SQLServer.2012.Database.LogShippingDestinationMonitorMicrosoft.SQLServer.2012.DatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.2SingleEventLog2StateMonitorTypeTruePublic
Microsoft.SQLServer.2012.Database.LogShippingSourceMonitor日志传送源此监视器检测日志传送源尚未在阈值(作为日志传送配置的一部分定义)内备份其日志的情况。 请注意,任何版本的 SQL Server Express 均不支持日志传送。Microsoft.SQLServer.2012.Database.LogShippingSourceMonitorMicrosoft.SQLServer.2012.DatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.2SingleEventLog2StateMonitorTypeTruePublic
Microsoft.SQLServer.2012.Database.ServiceMonitorSQL Server Windows 服务此监视器检查 SQL 数据库引擎服务的状态。Microsoft.SQLServer.2012.Database.ServiceMonitorMicrosoft.SQLServer.2012.DatabaseSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.2012.CheckDBEngineServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2012.Database.TransactionLogSpaceFreePercentMonitor事务日志可用空间(\%)针对 2012 数据库的事务日志可用空间(\%)监视器Microsoft.SQLServer.2012.Database.TransactionLogSpaceFreePercentMonitorMicrosoft.SQLServer.2012.DatabaseMicrosoft.SQLServer.2012.Database.DBSpaceMonitorPerformanceHealthFalse0TrueErrorNormalTrueMicrosoft.SQLServer.2012.Database.TransactionLogSpaceFreePercent.MonitorTypeTruePublic
Microsoft.SQLServer.2012.DBEngine.AverageWaitTimeMonitor平均等待时间针对 2012 数据库的平均等待时间监视器Microsoft.SQLServer.2012.DBEngine.AverageWaitTimeMonitorMicrosoft.SQLServer.2012.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0TrueWarningNormalTrueMicrosoft.SQLServer.2012.DBEngine.AverageWaitTime.MonitorTypeTruePublic
Microsoft.SQLServer.2012.DBEngine.BlockedSPIDsMonitor正在阻塞的会话监视 SQL 实例的阻塞的会话。Microsoft.SQLServer.2012.DBEngine.BlockedSPIDsMonitorMicrosoft.SQLServer.2012.DBEngineSystem.Health.PerformanceStatePerformanceHealthFalse0TrueErrorHighTrueMicrosoft.SQLServer.2012.DBEngine.BlockedSPIDsTruePublic
Microsoft.SQLServer.2012.DBEngine.BufferCacheHitRatioMonitor高速缓存命中率针对 2012 数据库引擎的缓冲区缓存命中率Microsoft.SQLServer.2012.DBEngine.BufferCacheHitRatioMonitorMicrosoft.SQLServer.2012.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2012.DBEngine.BufferCacheHitRatio.MonitorTypeTruePublic
Microsoft.SQLServer.2012.DBEngine.Configuration.ServicePackLevelService Pack 相容性根据兼容设置监视数据库引擎的 Service Pack 级别Microsoft.SQLServer.2012.DBEngine.Configuration.ServicePackLevelMicrosoft.SQLServer.2012.DBEngineSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2012.ServicePackVersionTruePublic
Microsoft.SQLServer.2012.DBEngine.Configuration.SPNStatusMonitor服务主体名称配置状态此监视器检查 Microsoft® SQL Server™ 实例服务主体名称配置的状态。Microsoft.SQLServer.2012.DBEngine.Configuration.SPNStatusMonitorMicrosoft.SQLServer.2012.DBEngineSystem.Health.ConfigurationStateAvailabilityHealthTrue0TrueWarningNormalTrueMicrosoft.SQLServer.2012.DBEngine.Configuration.SPNStatusTruePublic
Microsoft.SQLServer.2012.DBEngine.CPUUsagePercentMonitorCPU 使用率(\%)针对 2012 数据库引擎的 CPU 使用率(\%)Microsoft.SQLServer.2012.DBEngine.CPUUsagePercentMonitorMicrosoft.SQLServer.2012.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2012.DBEngine.CPUUsagePercent.MonitorTypeTruePublic
Microsoft.SQLServer.2012.DBEngine.FullTextSearchServiceMonitorSQL Server 全文筛选器后台程序启动器服务此监视器检查 SQL 全文筛选器后台程序启动器服务的状态。请注意,除具有高级服务的 SQL Server Express 外,SQL 全文搜索功能不适用于任何版本的 SQL Server Express。默认情况下,此监视器为禁用状态。请根据需要使用替代进行启用。Microsoft.SQLServer.2012.DBEngine.FullTextSearchServiceMonitorMicrosoft.SQLServer.2012.DBEngineSystem.Health.AvailabilityStateAvailabilityHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2012.DBEngine.PageLifeExpectancyMonitor页生存期2012 数据库引擎的页生存期Microsoft.SQLServer.2012.DBEngine.PageLifeExpectancyMonitorMicrosoft.SQLServer.2012.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2012.DBEngine.PageLifeExpectancy.MonitorTypeTruePublic
Microsoft.SQLServer.2012.DBEngine.ServiceMonitorSQL Server Windows 服务此监视器检查 SQL 数据库引擎服务的状态。Microsoft.SQLServer.2012.DBEngine.ServiceMonitorMicrosoft.SQLServer.2012.DBEngineSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2012.CheckWinServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2012.DBEngine.SQLReCompilationMonitorSQL 重新编译针对 2012 数据库引擎的 SQL 重新编译Microsoft.SQLServer.2012.DBEngine.SQLReCompilationMonitorMicrosoft.SQLServer.2012.DBEngineSystem.Health.PerformanceStatePerformanceHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2012.DBEngine.SQLReCompilation.MonitorTypeTruePublic
Microsoft.SQLServer.2012.DBEngine.StolenServerMemoryMonitor盗用的服务器内存针对 2012 数据库引擎的盗用的服务器内存Microsoft.SQLServer.2012.DBEngine.StolenServerMemoryMonitorMicrosoft.SQLServer.2012.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2012.DBEngine.StolenServerMemory.MonitorTypeTruePublic
Microsoft.SQLServer.2012.DBEngine.ThreadCountMonitor线程计数针对 2012 数据库引擎的线程计数Microsoft.SQLServer.2012.DBEngine.ThreadCountMonitorMicrosoft.SQLServer.2012.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2012.DBEngine.ThreadCount.MonitorTypeTruePublic
Microsoft.SQLServer.2012.DBEngine.UserConnectionsBaselineMonitorSQL 用户连接性能此监视器分析一段时间内 SQL 数据库引擎的用户连接并计算初始学习期间的基线。Microsoft.SQLServer.2012.DBEngine.UserConnectionsBaselineMonitorMicrosoft.SQLServer.2012.DBEngineSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueSystem.Performance.TwoStateAboveBaseliningMonitorWithoutCompressionTruePublic
Microsoft.SQLServer.2012.DBErrorUserPolicyStateMonitor数据库运行状况策略具有“错误”严重状态的两状态监视器,专用于反映将数据库作为方面以及将预定义错误类别之一作为策略类别的自定义用户策略的状态。Microsoft.SQLServer.2012.DBErrorUserPolicyStateMonitorMicrosoft.SQLServer.2012.DatabaseErrorUserPolicySystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.2012.TwoStatePolicyMonitorTypeTruePublic
Microsoft.SQLServer.2012.DBWarningUserPolicyStateMonitor数据库运行状况策略具有“警告”严重状态的两状态监视器,专用于反映将数据库作为方面以及将预定义警告类别之一作为策略类别的自定义用户策略的状态。Microsoft.SQLServer.2012.DBWarningUserPolicyStateMonitorMicrosoft.SQLServer.2012.DatabaseWarningUserPolicySystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.2012.TwoStatePolicyMonitorTypeTruePublic
Microsoft.SQLServer.2012.IntegrationServices.ServiceMonitorSQL Server Integration Services Windows 服务此监视器检查 SQL Integration Services 服务的状态。 请注意,所有 SQL Express 版本仅支持 SQL Server 导入和导出向导,以及内置数据源连接器。没有合适的发现对象(服务)。Microsoft.SQLServer.2012.IntegrationServices.ServiceMonitorMicrosoft.SQLServer.2012.IntegrationServicesSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2012.Monitoring.DBFileSpaceMonitor数据库文件空间监视数据库文件中的可用空间以及承载文件的介质的可用空间(以百分比表示)。Microsoft.SQLServer.2012.Monitoring.DBFileSpaceMonitorMicrosoft.SQLServer.2012.DBFileSystem.Health.PerformanceStatePerformanceHealthTrue0FalseTrueMicrosoft.SQLServer.2012.DBFileSizeMonitorTypeTruePublic
Microsoft.SQLServer.2012.Monitoring.DBFileStreamGroupSpaceMonitor数据库 FILESTREAM 文件组可用空间当可用空间低于“警告阈值”设置(以数据大小之和的百分比表示)时,监视器将报告警报。当可用空间低于“严重阈值”时,监视器将报告严重警报。Microsoft.SQLServer.2012.Monitoring.DBFileStreamGroupSpaceMonitorMicrosoft.SQLServer.2012.DBFileGroupFdSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2012.DBFileStreamGroupSizeMonitorTypeTruePublic
Microsoft.SQLServer.2012.Monitoring.DBLogFileSpaceMonitor数据库日志文件空间监视日志文件中的可用空间以及承载日志的介质的可用空间(以百分比表示)。Microsoft.SQLServer.2012.Monitoring.DBLogFileSpaceMonitorMicrosoft.SQLServer.2012.DBLogFileSystem.Health.PerformanceStatePerformanceHealthTrue0FalseTrueMicrosoft.SQLServer.2012.DBLogFileSizeMonitorTypeTruePublic
Microsoft.SQLServer.2012.ReportingServices.ServiceMonitorSQL Server Reporting Services Windows 服务此监视器检查 SQL Reporting Services 服务的状态。 请注意,除了具有高级服务的 SQL Server Express 外,其他任何版本的 SQL Server Express 均不支持 SQL Server Reporting Services Windows 服务。Microsoft.SQLServer.2012.ReportingServices.ServiceMonitorMicrosoft.SQLServer.2012.ReportingServicesSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic