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 JobsMicrosoft.SQLServer.2005.Agent.LongRunningJobsMicrosoft.SQLServer.2005.AgentSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2005.AgentLongRunningJobsProviderTruePublic
Microsoft.SQLServer.2005.Agent.ServiceMonitorSQL Server Agent Windows ServiceMicrosoft.SQLServer.2005.Agent.ServiceMonitorMicrosoft.SQLServer.2005.AgentSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2005.AgentJob.JobDurationJob DurationMicrosoft.SQLServer.2005.AgentJob.JobDurationMicrosoft.SQLServer.2005.AgentJobSystem.Health.PerformanceStatePerformanceCollectionTrue0FalseTrueMicrosoft.SQLServer.2005.AgentLongRunningJobsProviderPerJobTruePublic
Microsoft.SQLServer.2005.AgentJob.JobLastRunStateLast Run StatusMicrosoft.SQLServer.2005.AgentJob.JobLastRunStateMicrosoft.SQLServer.2005.AgentJobSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.2005.AgentJobLastRunProviderTruePublic
Microsoft.SQLServer.2005.AnalysisServices.ServiceMonitorSQL Server Analysis Services Windows ServiceMicrosoft.SQLServer.2005.AnalysisServices.ServiceMonitorMicrosoft.SQLServer.2005.AnalysisServicesSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2005.Database.Configuration.AutoCloseAuto Close FlagMonitors the auto close flag on the databaseMicrosoft.SQLServer.2005.Database.Configuration.AutoCloseMicrosoft.SQLServer.2005.DatabaseSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2005.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2005.Database.Configuration.AutoCreateStatAuto Create Statistics FlagMonitors the automatically create statistics flag on the databaseMicrosoft.SQLServer.2005.Database.Configuration.AutoCreateStatMicrosoft.SQLServer.2005.DatabaseSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2005.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2005.Database.Configuration.AutoShrinkAuto Shrink FlagMonitors the auto shrink flag on the databaseMicrosoft.SQLServer.2005.Database.Configuration.AutoShrinkMicrosoft.SQLServer.2005.DatabaseSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2005.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2005.Database.Configuration.AutoUpdateSetAuto Update FlagMonitors the auto update flag on the databaseMicrosoft.SQLServer.2005.Database.Configuration.AutoUpdateSetMicrosoft.SQLServer.2005.DatabaseSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2005.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2005.Database.Configuration.DBChainingDB Chaining FlagMonitors the database chaining flag on the databaseMicrosoft.SQLServer.2005.Database.Configuration.DBChainingMicrosoft.SQLServer.2005.DatabaseSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2005.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2005.Database.Configuration.TornPageDetectionTorn Page DetectionMicrosoft.SQLServer.2005.Database.Configuration.TornPageDetectionMicrosoft.SQLServer.2005.DatabaseSystem.Health.ConfigurationStateConfigurationHealthFalse0TrueErrorNormalTrueMicrosoft.SQLServer.2005.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2005.Database.DBSizeMegabytesMonitorDB Space Free (MB) Monitors for the free space left in the database in terms of megabytes.Microsoft.SQLServer.2005.Database.DBSizeMegabytesMonitorMicrosoft.SQLServer.2005.DatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2005.DBAndLogSizeMonitorTypeTruePublic
Microsoft.SQLServer.2005.Database.DBSizePercentageChangeMonitorPercentage Change in DB \% Used SpaceMonitors for a large change in value of DB used space over a set number of sample periods. A rapid large change in value could indicate a problemMicrosoft.SQLServer.2005.Database.DBSizePercentageChangeMonitorMicrosoft.SQLServer.2005.DatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2005.DBPercentageChangeTruePublic
Microsoft.SQLServer.2005.Database.DBSizePercentMonitorDB Space Free (\%) Monitors for the free space left in the database in percentage terms.Microsoft.SQLServer.2005.Database.DBSizePercentMonitorMicrosoft.SQLServer.2005.DatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2005.DBAndLogSizeMonitorTypeTruePublic
Microsoft.SQLServer.2005.Database.DBStatusMonitorDatabase StatusMicrosoft.SQLServer.2005.Database.DBStatusMonitorMicrosoft.SQLServer.2005.DatabaseSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2005.DBStatusTruePublic
Microsoft.SQLServer.2005.Database.LogShippingDestinationMonitorDestination Log Shipping MonitorMicrosoft.SQLServer.2005.Database.LogShippingDestinationMonitorMicrosoft.SQLServer.2005.DatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.2SingleEventLog2StateMonitorTypeTruePublic
Microsoft.SQLServer.2005.Database.LogShippingSourceMonitorSource Log Shipping Monitor Microsoft.SQLServer.2005.Database.LogShippingSourceMonitorMicrosoft.SQLServer.2005.DatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.2SingleEventLog2StateMonitorTypeTruePublic
Microsoft.SQLServer.2005.Database.TransactionLogSizeMegabytesMonitorTransaction Log Space Free (MB) Monitors for the free space left in the transaction log in percentage terms.Microsoft.SQLServer.2005.Database.TransactionLogSizeMegabytesMonitorMicrosoft.SQLServer.2005.DatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2005.DBAndLogSizeMonitorTypeTruePublic
Microsoft.SQLServer.2005.Database.TransactionLogSizePercentMonitorTransaction Log Space Free (\%) Monitors for the free space left in the transaction log in percentage terms.Microsoft.SQLServer.2005.Database.TransactionLogSizePercentMonitorMicrosoft.SQLServer.2005.DatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2005.DBAndLogSizeMonitorTypeTruePublic
Microsoft.SQLServer.2005.DBEngine.BlockedSPIDsMonitorBlocking SPIDsMicrosoft.SQLServer.2005.DBEngine.BlockedSPIDsMonitorMicrosoft.SQLServer.2005.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0FalseTrueMicrosoft.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.ConfigurationStateConfigurationHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2005.ServicePackVersionTruePublic
Microsoft.SQLServer.2005.DBEngine.FullTextSearchServiceMonitorSQL Server Full Text Search Service MonitorMicrosoft.SQLServer.2005.DBEngine.FullTextSearchServiceMonitorMicrosoft.SQLServer.2005.DBEngineSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2005.DBEngine.ServiceMonitorSQL Server Windows ServiceMicrosoft.SQLServer.2005.DBEngine.ServiceMonitorMicrosoft.SQLServer.2005.DBEngineSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2005.DBEngine.UserConnectionsBaselineMonitorSQL User Connections PerformanceMicrosoft.SQLServer.2005.DBEngine.UserConnectionsBaselineMonitorMicrosoft.SQLServer.2005.DBEngineSystem.Health.PerformanceStatePerformanceHealthFalse0TrueErrorNormalTrueSystem.Performance.TwoStateAboveBaseliningMonitorWithoutCompressionTruePublic
Microsoft.SQLServer.2005.DBFile.DiskFreeSpaceDisk Free SpaceMicrosoft.SQLServer.2005.DBFile.DiskFreeSpaceMicrosoft.SQLServer.2005.DBFileSystem.Health.PerformanceStatePerformanceHealthTrueLogicalDisk\% Free Space3600TrueErrorNormalTrueSystem.Performance.ThresholdMonitorTypeTruePublic
Microsoft.SQLServer.2005.IntegrationServices.ServiceMonitorSQL Server Integration Services Windows ServiceMicrosoft.SQLServer.2005.IntegrationServices.ServiceMonitorMicrosoft.SQLServer.2005.IntegrationServicesSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2005.ReportingServices.ServiceMonitorSQL Server Reporting Services Windows ServiceMicrosoft.SQLServer.2005.ReportingServices.ServiceMonitorMicrosoft.SQLServer.2005.ReportingServicesSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic