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

 DisplayNameDescriptionIDTargetParent MonitorCategoryEnabledInstance NameCounter NameFrequencyAlert GenerateAlert SeverityAlert PriorityAlert Auto ResolveMonitor TypeRemotableAccessibilityRunAs
Microsoft.SQLServer.2005.Agent.LongRunningJobsLong Running JobsThis monitor checks for long running SQL Agent jobs. Microsoft.SQLServer.2005.Agent.LongRunningJobsMicrosoft.SQLServer.2005.AgentSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2005.AgentLongRunningJobsProviderTruePublic
Microsoft.SQLServer.2005.Agent.ServiceMonitorSQL Server Agent Windows ServiceThis monitor checks the status of the SQL Agent service for this instance of SQL Server.Microsoft.SQLServer.2005.Agent.ServiceMonitorMicrosoft.SQLServer.2005.AgentSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2005.AgentJob.JobDurationJob DurationMonitors Agent Job Duration.Microsoft.SQLServer.2005.AgentJob.JobDurationMicrosoft.SQLServer.2005.AgentJobSystem.Health.PerformanceStatePerformanceCollectionTrue0FalseTrueMicrosoft.SQLServer.2005.AgentLongRunningJobsProviderPerJobTruePublic
Microsoft.SQLServer.2005.AgentJob.JobLastRunStateLast Run StatusSQL 2005 Agent Job Last Run State Monitor. Monitors the last run state of an SQL Agent Job.Microsoft.SQLServer.2005.AgentJob.JobLastRunStateMicrosoft.SQLServer.2005.AgentJobSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.2005.AgentJobLastRunProviderTruePublic
Microsoft.SQLServer.2005.AnalysisServices.ServiceMonitorSQL Server Analysis Services Windows ServiceThis monitor checks the status of the SQL Analysis Services service.Microsoft.SQLServer.2005.AnalysisServices.ServiceMonitorMicrosoft.SQLServer.2005.AnalysisServicesSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2005.Database.Configuration.AutoCloseAuto Close ConfigurationMonitors the auto close setting for the databaseMicrosoft.SQLServer.2005.Database.Configuration.AutoCloseMicrosoft.SQLServer.2005.DatabaseMicrosoft.SQLServer.2005.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2005.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2005.Database.Configuration.AutoCreateStatAuto Create Statistics ConfigurationMonitors the auto create statistic setting for the databaseMicrosoft.SQLServer.2005.Database.Configuration.AutoCreateStatMicrosoft.SQLServer.2005.DatabaseMicrosoft.SQLServer.2005.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2005.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2005.Database.Configuration.AutoShrinkAuto Shrink ConfigurationMonitors the auto shrink setting for the databaseMicrosoft.SQLServer.2005.Database.Configuration.AutoShrinkMicrosoft.SQLServer.2005.DatabaseMicrosoft.SQLServer.2005.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2005.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2005.Database.Configuration.AutoUpdateSetAuto Update Statistics ConfigurationMonitors the auto update statistics setting for the databaseMicrosoft.SQLServer.2005.Database.Configuration.AutoUpdateSetMicrosoft.SQLServer.2005.DatabaseMicrosoft.SQLServer.2005.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2005.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2005.Database.Configuration.AutoUpdateStatAsyncAuto Update Statistics Async ConfigurationMonitors the auto update statistics async setting for the databaseMicrosoft.SQLServer.2005.Database.Configuration.AutoUpdateStatAsyncMicrosoft.SQLServer.2005.DatabaseMicrosoft.SQLServer.2005.Database.AutomaticConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2005.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2005.Database.Configuration.DBChainingDB Chaining ConfigurationMonitors the DB chaining setting for the databaseMicrosoft.SQLServer.2005.Database.Configuration.DBChainingMicrosoft.SQLServer.2005.DatabaseMicrosoft.SQLServer.2005.Database.ExternalAccessConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2005.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2005.Database.Configuration.RecoveryModelRecovery Model ConfigurationMonitors the recovery model setting for the database.Microsoft.SQLServer.2005.Database.Configuration.RecoveryModelMicrosoft.SQLServer.2005.DatabaseMicrosoft.SQLServer.2005.Database.RecoveryConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2005.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2005.Database.Configuration.TornPageDetectionPage Verify ConfigurationMonitors the page verify setting for the database.Microsoft.SQLServer.2005.Database.Configuration.TornPageDetectionMicrosoft.SQLServer.2005.DatabaseMicrosoft.SQLServer.2005.Database.RecoveryConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2005.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2005.Database.Configuration.TrustWorthyTrustworthy ConfigurationMonitors the trustworthy setting for the databaseMicrosoft.SQLServer.2005.Database.Configuration.TrustWorthyMicrosoft.SQLServer.2005.DatabaseMicrosoft.SQLServer.2005.Database.ExternalAccessConfigurationConfigurationHealthFalse0TrueWarningNormalTrueMicrosoft.SQLServer.2005.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2005.Database.DBSizeMegabytesMonitorDB Space Free (MB) : DEPRECATEDThis monitor is DEPRECATED. Monitors for the free space left in the database in terms of megabytes.Microsoft.SQLServer.2005.Database.DBSizeMegabytesMonitorMicrosoft.SQLServer.2005.DatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0FalseTrueMicrosoft.SQLServer.2005.DBAndLogSizeMonitorTypeTruePublic
Microsoft.SQLServer.2005.Database.DBSizePercentageChangeMonitorDB Space Percentage ChangeMonitors for a large change in value of database available space over a set number of sample periods.Microsoft.SQLServer.2005.Database.DBSizePercentageChangeMonitorMicrosoft.SQLServer.2005.DatabaseMicrosoft.SQLServer.2005.Database.DBSpaceMonitorPerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2005.DBPercentageChangeTruePublic
Microsoft.SQLServer.2005.Database.DBSizePercentMonitorDB Total SpaceMonitors the space available in the database and on the media hosting the database in percentage terms.Microsoft.SQLServer.2005.Database.DBSizePercentMonitorMicrosoft.SQLServer.2005.DatabaseMicrosoft.SQLServer.2005.Database.DBSpaceMonitorPerformanceHealthFalse0TrueMatchMonitorHealthHighTrueMicrosoft.SQLServer.2005.DBAndLogSizeMonitorTypeTruePublic
Microsoft.SQLServer.2005.Database.DBStatusMonitorDatabase StatusThis monitor checks the status of the database as reported by Microsoft® SQL Server™. Microsoft.SQLServer.2005.Database.DBStatusMonitorMicrosoft.SQLServer.2005.DatabaseSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2005.DBStatusTruePublic
Microsoft.SQLServer.2005.Database.LogShippingDestinationMonitorDestination Log ShippingThis monitor detects when a log shipping destination has not had a log restored to it within the threshold defined as a part of the log shipping configuration. Microsoft.SQLServer.2005.Database.LogShippingDestinationMonitorMicrosoft.SQLServer.2005.DatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.2SingleEventLog2StateMonitorTypeTruePublic
Microsoft.SQLServer.2005.Database.LogShippingSourceMonitorSource Log ShippingThis monitor detects when a log shipping source has not had its logs backed up within the threshold defined as a part of the log shipping configuration.Microsoft.SQLServer.2005.Database.LogShippingSourceMonitorMicrosoft.SQLServer.2005.DatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.2SingleEventLog2StateMonitorTypeTruePublic
Microsoft.SQLServer.2005.Database.ServiceMonitorSQL Server Windows ServiceThis monitor checks the status of the SQL Database Engine service.Microsoft.SQLServer.2005.Database.ServiceMonitorMicrosoft.SQLServer.2005.DatabaseSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.2005.CheckDBEngineServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2005.Database.TransactionLogSizeMegabytesMonitorDB Log File Space Free (MB) : DEPRECATEDThis monitor is DEPRECATED. Monitors the space available on the log files and on the media hosting the log files in megabytes.Microsoft.SQLServer.2005.Database.TransactionLogSizeMegabytesMonitorMicrosoft.SQLServer.2005.DatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2005.DBAndLogSizeMonitorTypeTruePublic
Microsoft.SQLServer.2005.Database.TransactionLogSizePercentMonitorDB Log File Space Free (\%) : DEPRECATEDThis monitor is DEPRECATED. Monitors the space available on the log files and on the media hosting the log in percentage terms.Microsoft.SQLServer.2005.Database.TransactionLogSizePercentMonitorMicrosoft.SQLServer.2005.DatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2005.DBAndLogSizeMonitorTypeTruePublic
Microsoft.SQLServer.2005.DBEngine.BlockedSPIDsMonitorBlocking SessionsMonitors blocked sessions for a SQL instance.Microsoft.SQLServer.2005.DBEngine.BlockedSPIDsMonitorMicrosoft.SQLServer.2005.DBEngineSystem.Health.PerformanceStatePerformanceHealthFalse0TrueErrorHighTrueMicrosoft.SQLServer.2005.DBEngine.BlockedSPIDsTruePublic
Microsoft.SQLServer.2005.DBEngine.Configuration.ServicePackLevelService Pack ComplianceMonitors the service pack level of the database engine against the compliant settingMicrosoft.SQLServer.2005.DBEngine.Configuration.ServicePackLevelMicrosoft.SQLServer.2005.DBEngineSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2005.ServicePackVersionTruePublic
Microsoft.SQLServer.2005.DBEngine.CPUUsagePercentMonitorCPU Utilization (\%)CPU Utilization (\%) for 2005 DB EngineMicrosoft.SQLServer.2005.DBEngine.CPUUsagePercentMonitorMicrosoft.SQLServer.2005.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2005.DBEngine.CPUUsagePercent.MonitorTypeTruePublic
Microsoft.SQLServer.2005.DBEngine.FullTextSearchServiceMonitorSQL Server Full Text Search ServiceThis monitor checks the status of the SQL Full Text Search service.Microsoft.SQLServer.2005.DBEngine.FullTextSearchServiceMonitorMicrosoft.SQLServer.2005.DBEngineSystem.Health.AvailabilityStateAvailabilityHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2005.DBEngine.ServiceMonitorSQL Server Windows ServiceThis monitor checks the status of the SQL Database Engine service.Microsoft.SQLServer.2005.DBEngine.ServiceMonitorMicrosoft.SQLServer.2005.DBEngineSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2005.CheckWinServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2005.DBEngine.UserConnectionsBaselineMonitorSQL User Connections PerformanceThis monitor analysis the user connections to the SQL database engine over time and calculates a baseline over the initial learning period.Microsoft.SQLServer.2005.DBEngine.UserConnectionsBaselineMonitorMicrosoft.SQLServer.2005.DBEngineSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueSystem.Performance.TwoStateAboveBaseliningMonitorWithoutCompressionTruePublic
Microsoft.SQLServer.2005.DBFile.DiskFreeSpaceDisk Free Space : DEPRECATEDMonitors the free space percentage left on a disk drive.Microsoft.SQLServer.2005.DBFile.DiskFreeSpaceMicrosoft.SQLServer.2005.DBFileSystem.Health.PerformanceStatePerformanceHealthFalseLogicalDisk\% Free Space3600TrueErrorNormalTrueSystem.Performance.ThresholdMonitorTypeTruePublic
Microsoft.SQLServer.2005.IntegrationServices.ServiceMonitorSQL Server Integration Services Windows ServiceThis monitor checks the status of the SQL Integration Services service.Microsoft.SQLServer.2005.IntegrationServices.ServiceMonitorMicrosoft.SQLServer.2005.IntegrationServicesSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2005.Monitoring.DBFileSpaceMonitorDB File SpaceMonitors the space available on a database file and on the media hosting the file in percentage terms.Microsoft.SQLServer.2005.Monitoring.DBFileSpaceMonitorMicrosoft.SQLServer.2005.DBFileSystem.Health.PerformanceStatePerformanceHealthTrue0FalseTrueMicrosoft.SQLServer.2005.DBFileSizeMonitorTypeTruePublic
Microsoft.SQLServer.2005.Monitoring.DBLogFileSpaceMonitorDB Log File SpaceMonitors the space available on a log file and on the media hosting the log in percentage terms.Microsoft.SQLServer.2005.Monitoring.DBLogFileSpaceMonitorMicrosoft.SQLServer.2005.DBLogFileSystem.Health.PerformanceStatePerformanceHealthTrue0FalseTrueMicrosoft.SQLServer.2005.DBLogFileSizeMonitorTypeTruePublic
Microsoft.SQLServer.2005.ReportingServices.ServiceMonitorSQL Server Reporting Services Windows ServiceThis monitor checks the status of the SQL Reporting Services service.Microsoft.SQLServer.2005.ReportingServices.ServiceMonitorMicrosoft.SQLServer.2005.ReportingServicesSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic