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

 DisplayNameDescriptionIDTargetParent MonitorCategoryEnabledInstance NameCounter NameFrequencyAlert GenerateAlert SeverityAlert PriorityAlert Auto ResolveMonitor TypeRemotableAccessibilityRunAs
Microsoft.SQLServer.2008.Agent.LongRunningJobs长时间运行的作业此监视器检查长期运行的 SQL 代理作业。Microsoft.SQLServer.2008.Agent.LongRunningJobsMicrosoft.SQLServer.2008.AgentSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2008.AgentLongRunningJobsProviderTruePublic
Microsoft.SQLServer.2008.Agent.ServiceMonitorSQL Server 代理 Windows 服务此监视器检查此 SQL Server 实例的 SQL 代理服务的状态。Microsoft.SQLServer.2008.Agent.ServiceMonitorMicrosoft.SQLServer.2008.AgentSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2008.AgentJob.JobDuration作业周期监视代理作业周期。Microsoft.SQLServer.2008.AgentJob.JobDurationMicrosoft.SQLServer.2008.AgentJobSystem.Health.PerformanceStatePerformanceCollectionTrue0FalseTrueMicrosoft.SQLServer.2008.AgentLongRunningJobsProviderPerJobTruePublic
Microsoft.SQLServer.2008.AgentJob.JobLastRunState上次运行状态SQL 2008 代理作业上次运行状态监视器。监视 SQL 代理作业上次运行的状态。Microsoft.SQLServer.2008.AgentJob.JobLastRunStateMicrosoft.SQLServer.2008.AgentJobSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.2008.AgentJobLastRunProviderTruePublic
Microsoft.SQLServer.2008.AnalysisServices.ServiceMonitorSQL Server Analysis Services Windows 服务此监视器检查 SQL Analysis Services 服务的状态。Microsoft.SQLServer.2008.AnalysisServices.ServiceMonitorMicrosoft.SQLServer.2008.AnalysisServicesSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2008.Database.Configuration.AutoClose自动关闭配置监视数据库的自动关闭设置Microsoft.SQLServer.2008.Database.Configuration.AutoCloseMicrosoft.SQLServer.2008.DatabaseMicrosoft.SQLServer.2008.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2008.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2008.Database.Configuration.AutoCreateStat自动创建统计信息配置监视数据库的自动创建统计信息Microsoft.SQLServer.2008.Database.Configuration.AutoCreateStatMicrosoft.SQLServer.2008.DatabaseMicrosoft.SQLServer.2008.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2008.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2008.Database.Configuration.AutoShrink自动收缩配置监视数据库的自动收缩设置Microsoft.SQLServer.2008.Database.Configuration.AutoShrinkMicrosoft.SQLServer.2008.DatabaseMicrosoft.SQLServer.2008.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2008.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2008.Database.Configuration.AutoUpdateSet自动更新统计信息配置监视数据库的自动更新统计信息设置Microsoft.SQLServer.2008.Database.Configuration.AutoUpdateSetMicrosoft.SQLServer.2008.DatabaseMicrosoft.SQLServer.2008.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2008.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2008.Database.Configuration.AutoUpdateStatAsync自动异步更新统计信息配置监视数据库的自动异步更新统计信息设置Microsoft.SQLServer.2008.Database.Configuration.AutoUpdateStatAsyncMicrosoft.SQLServer.2008.DatabaseMicrosoft.SQLServer.2008.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2008.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2008.Database.Configuration.DBChaining数据库链接配置监视数据库的数据库链接设置Microsoft.SQLServer.2008.Database.Configuration.DBChainingMicrosoft.SQLServer.2008.DatabaseMicrosoft.SQLServer.2008.Database.ExternalAccessConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2008.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2008.Database.Configuration.RecoveryModel恢复模式配置监视数据库的恢复模式设置。Microsoft.SQLServer.2008.Database.Configuration.RecoveryModelMicrosoft.SQLServer.2008.DatabaseMicrosoft.SQLServer.2008.Database.RecoveryConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2008.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2008.Database.Configuration.TornPageDetection页验证配置监视数据库的页验证设置。Microsoft.SQLServer.2008.Database.Configuration.TornPageDetectionMicrosoft.SQLServer.2008.DatabaseMicrosoft.SQLServer.2008.Database.RecoveryConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2008.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2008.Database.Configuration.TrustWorthy可信配置监视数据库的可信设置Microsoft.SQLServer.2008.Database.Configuration.TrustWorthyMicrosoft.SQLServer.2008.DatabaseMicrosoft.SQLServer.2008.Database.ExternalAccessConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2008.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2008.Database.DBBackupStatusMonitor数据库备份状态此监视器检查 Microsoft® SQL Server™ 报告的数据库备份状态。Microsoft.SQLServer.2008.Database.DBBackupStatusMonitorMicrosoft.SQLServer.2008.DatabaseSystem.Health.AvailabilityStateAvailabilityHealthFalse0TrueErrorNormalTrueMicrosoft.SQLServer.2008.DBBackupStatusTruePublic
Microsoft.SQLServer.2008.Database.DBSizeMegabytesMonitor数据库可用空间(MB): 不推荐使用不推荐使用此监视器。监视数据库的剩余可用空间(以 MB 表示)。Microsoft.SQLServer.2008.Database.DBSizeMegabytesMonitorMicrosoft.SQLServer.2008.DatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0FalseTrueMicrosoft.SQLServer.2008.DBAndLogSizeMonitorTypeTruePublic
Microsoft.SQLServer.2008.Database.DBSizePercentageChangeMonitor数据库空间百分比更改监视在一定的采样期间数据库可用空间值的显著更改。Microsoft.SQLServer.2008.Database.DBSizePercentageChangeMonitorMicrosoft.SQLServer.2008.DatabaseMicrosoft.SQLServer.2008.Database.DBSpaceMonitorPerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2008.DBPercentageChangeTruePublic
Microsoft.SQLServer.2008.Database.DBSizePercentMonitor数据库总空间监视数据库中的可用空间以及承载数据库的介质的可用空间(以百分比表示)。Microsoft.SQLServer.2008.Database.DBSizePercentMonitorMicrosoft.SQLServer.2008.DatabaseMicrosoft.SQLServer.2008.Database.DBSpaceMonitorPerformanceHealthFalse0TrueMatchMonitorHealthHighTrueMicrosoft.SQLServer.2008.DBAndLogSizeMonitorTypeTruePublic
Microsoft.SQLServer.2008.Database.DBStatusMonitor数据库状态此监视器检查 Microsoft® SQL Server™ 报告的数据库状态。Microsoft.SQLServer.2008.Database.DBStatusMonitorMicrosoft.SQLServer.2008.DatabaseSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2008.DBStatusTruePublic
Microsoft.SQLServer.2008.Database.DiskReadLatencyMonitor磁盘读取延迟针对 2008 数据库的磁盘读取延迟监视器Microsoft.SQLServer.2008.Database.DiskReadLatencyMonitorMicrosoft.SQLServer.2008.DatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueErrorNormalTrueMicrosoft.SQLServer.2008.Database.DiskReadLatency.MonitorTypeTruePublic
Microsoft.SQLServer.2008.Database.DiskWriteLatencyMonitor磁盘写入延迟针对 2008 数据库的磁盘写入延迟监视器Microsoft.SQLServer.2008.Database.DiskWriteLatencyMonitorMicrosoft.SQLServer.2008.DatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueErrorNormalTrueMicrosoft.SQLServer.2008.Database.DiskWriteLatency.MonitorTypeTruePublic
Microsoft.SQLServer.2008.Database.LogShippingDestinationMonitor日志传送目标此监视器检测日志传送目标尚未在阈值(作为日志传送配置的一部分定义)内将日志还原到它的情况。Microsoft.SQLServer.2008.Database.LogShippingDestinationMonitorMicrosoft.SQLServer.2008.DatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.2SingleEventLog2StateMonitorTypeTruePublic
Microsoft.SQLServer.2008.Database.LogShippingSourceMonitor日志传送源此监视器检测日志传送源尚未在阈值(作为日志传送配置的一部分定义)内备份其日志的情况。Microsoft.SQLServer.2008.Database.LogShippingSourceMonitorMicrosoft.SQLServer.2008.DatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.2SingleEventLog2StateMonitorTypeTruePublic
Microsoft.SQLServer.2008.Database.ServiceMonitorSQL Server Windows 服务此监视器检查 SQL 数据库引擎服务的状态。Microsoft.SQLServer.2008.Database.ServiceMonitorMicrosoft.SQLServer.2008.DatabaseSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.2008.CheckDBEngineServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2008.Database.TransactionLogSizeMegabytesMonitor数据库日志文件可用空间(MB): 不推荐使用不推荐使用此监视器。监视日志文件中的可用空间以及承载日志文件的介质的可用空间(MB)。Microsoft.SQLServer.2008.Database.TransactionLogSizeMegabytesMonitorMicrosoft.SQLServer.2008.DatabaseMicrosoft.SQLServer.2008.Database.DBSpaceMonitorPerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2008.DBAndLogSizeMonitorTypeTruePublic
Microsoft.SQLServer.2008.Database.TransactionLogSizePercentMonitor数据库日志文件可用空间 (\%)监视日志文件中的可用空间以及承载日志的介质的可用空间(以百分比表示)。Microsoft.SQLServer.2008.Database.TransactionLogSizePercentMonitorMicrosoft.SQLServer.2008.DatabaseMicrosoft.SQLServer.2008.Database.DBSpaceMonitorPerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2008.DBAndLogSizeMonitorTypeTruePublic
Microsoft.SQLServer.2008.DBEngine.AverageWaitTimeMonitor平均等待时间针对 2008 数据库的平均等待时间监视器Microsoft.SQLServer.2008.DBEngine.AverageWaitTimeMonitorMicrosoft.SQLServer.2008.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0TrueWarningNormalTrueMicrosoft.SQLServer.2008.DBEngine.AverageWaitTime.MonitorTypeTruePublic
Microsoft.SQLServer.2008.DBEngine.BlockedSPIDsMonitor正在阻塞的会话监视 SQL 实例的阻塞的会话。Microsoft.SQLServer.2008.DBEngine.BlockedSPIDsMonitorMicrosoft.SQLServer.2008.DBEngineSystem.Health.PerformanceStatePerformanceHealthFalse0TrueErrorHighTrueMicrosoft.SQLServer.2008.DBEngine.BlockedSPIDsTruePublic
Microsoft.SQLServer.2008.DBEngine.BufferCacheHitRatioMonitor高速缓存命中率针对 2008 数据库引擎的缓冲区缓存命中率Microsoft.SQLServer.2008.DBEngine.BufferCacheHitRatioMonitorMicrosoft.SQLServer.2008.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2008.DBEngine.BufferCacheHitRatio.MonitorTypeTruePublic
Microsoft.SQLServer.2008.DBEngine.Configuration.ServicePackLevelService Pack 相容性根据兼容设置监视数据库引擎的 Service Pack 级别Microsoft.SQLServer.2008.DBEngine.Configuration.ServicePackLevelMicrosoft.SQLServer.2008.DBEngineSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2008.ServicePackVersionTruePublic
Microsoft.SQLServer.2008.DBEngine.Configuration.SPNStatusMonitor服务主体名称配置状态此监视器检查 Microsoft® SQL Server™ 实例服务主体名称配置的状态。Microsoft.SQLServer.2008.DBEngine.Configuration.SPNStatusMonitorMicrosoft.SQLServer.2008.DBEngineSystem.Health.ConfigurationStateAvailabilityHealthTrue0TrueWarningNormalTrueMicrosoft.SQLServer.2008.DBEngine.Configuration.SPNStatusTruePublic
Microsoft.SQLServer.2008.DBEngine.CPUUsagePercentMonitorCPU 使用率(\%)针对 2008 数据库引擎的 CPU 使用率(\%)Microsoft.SQLServer.2008.DBEngine.CPUUsagePercentMonitorMicrosoft.SQLServer.2008.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2008.DBEngine.CPUUsagePercent.MonitorTypeTruePublic
Microsoft.SQLServer.2008.DBEngine.FullTextSearchServiceMonitorSQL Server 全文搜索服务此监视器检查 SQL 全文搜索服务的状态。Microsoft.SQLServer.2008.DBEngine.FullTextSearchServiceMonitorMicrosoft.SQLServer.2008.DBEngineSystem.Health.AvailabilityStateAvailabilityHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2008.DBEngine.PageLifeExpectancyMonitor页生存期2008 数据库引擎的页生存期Microsoft.SQLServer.2008.DBEngine.PageLifeExpectancyMonitorMicrosoft.SQLServer.2008.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2008.DBEngine.PageLifeExpectancy.MonitorTypeTruePublic
Microsoft.SQLServer.2008.DBEngine.ServiceMonitorSQL Server Windows 服务此监视器检查 SQL 数据库引擎服务的状态。Microsoft.SQLServer.2008.DBEngine.ServiceMonitorMicrosoft.SQLServer.2008.DBEngineSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2008.CheckWinServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2008.DBEngine.SQLReCompilationMonitorSQL 重新编译针对 2008 数据库引擎的 SQL 重新编译Microsoft.SQLServer.2008.DBEngine.SQLReCompilationMonitorMicrosoft.SQLServer.2008.DBEngineSystem.Health.PerformanceStatePerformanceHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2008.DBEngine.SQLReCompilation.MonitorTypeTruePublic
Microsoft.SQLServer.2008.DBEngine.StolenServerMemoryMonitor盗用的服务器内存针对 2008 数据库引擎的盗用的服务器内存Microsoft.SQLServer.2008.DBEngine.StolenServerMemoryMonitorMicrosoft.SQLServer.2008.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2008.DBEngine.StolenServerMemory.MonitorTypeTruePublic
Microsoft.SQLServer.2008.DBEngine.ThreadCountMonitor线程计数针对 2008 数据库引擎的线程计数Microsoft.SQLServer.2008.DBEngine.ThreadCountMonitorMicrosoft.SQLServer.2008.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2008.DBEngine.ThreadCount.MonitorTypeTruePublic
Microsoft.SQLServer.2008.DBEngine.UserConnectionsBaselineMonitorSQL 用户连接性能此监视器分析一段时间内 SQL 数据库引擎的用户连接并计算初始学习期间的基线。Microsoft.SQLServer.2008.DBEngine.UserConnectionsBaselineMonitorMicrosoft.SQLServer.2008.DBEngineSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueSystem.Performance.TwoStateAboveBaseliningMonitorWithoutCompressionTruePublic
Microsoft.SQLServer.2008.DBFile.DiskFreeSpace磁盘可用空间: 不推荐使用监视磁盘驱动器上剩余的可用空间百分比。Microsoft.SQLServer.2008.DBFile.DiskFreeSpaceMicrosoft.SQLServer.2008.DBFileSystem.Health.PerformanceStatePerformanceHealthFalseLogicalDisk\% Free Space3600TrueErrorNormalTrueSystem.Performance.ThresholdMonitorTypeTruePublic
Microsoft.SQLServer.2008.IntegrationServices.ServiceMonitorSQL Server Integration Services Windows 服务此监视器检查 SQL Integration Services 服务的状态。Microsoft.SQLServer.2008.IntegrationServices.ServiceMonitorMicrosoft.SQLServer.2008.IntegrationServicesSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2008.Monitoring.DBFileSpaceMonitor数据库文件空间监视数据库文件中的可用空间以及承载文件的介质的可用空间(以百分比表示)。Microsoft.SQLServer.2008.Monitoring.DBFileSpaceMonitorMicrosoft.SQLServer.2008.DBFileSystem.Health.PerformanceStatePerformanceHealthTrue0FalseTrueMicrosoft.SQLServer.2008.DBFileSizeMonitorTypeTruePublic
Microsoft.SQLServer.2008.Monitoring.DBLogFileSpaceMonitor数据库日志文件空间监视日志文件中的可用空间以及承载日志的介质的可用空间(以百分比表示)。Microsoft.SQLServer.2008.Monitoring.DBLogFileSpaceMonitorMicrosoft.SQLServer.2008.DBLogFileSystem.Health.PerformanceStatePerformanceHealthTrue0FalseTrueMicrosoft.SQLServer.2008.DBLogFileSizeMonitorTypeTruePublic
Microsoft.SQLServer.2008.ReportingServices.ServiceMonitorSQL Server Reporting Services Windows 服务此监视器检查 SQL Reporting Services 服务的状态。Microsoft.SQLServer.2008.ReportingServices.ServiceMonitorMicrosoft.SQLServer.2008.ReportingServicesSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic