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

 DisplayNameDescriptionIDTargetParent MonitorCategoryEnabledInstance NameCounter NameFrequencyAlert GenerateAlert SeverityAlert PriorityAlert Auto ResolveMonitor TypeRemotableAccessibilityRunAs
Microsoft.SQLServer.2008.Agent.LongRunningJobsLong Running JobsMicrosoft.SQLServer.2008.Agent.LongRunningJobsMicrosoft.SQLServer.2008.AgentSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2008.AgentLongRunningJobsProviderTruePublic
Microsoft.SQLServer.2008.Agent.ServiceMonitorSQL Server Agent Windows ServiceMicrosoft.SQLServer.2008.Agent.ServiceMonitorMicrosoft.SQLServer.2008.AgentSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2008.AgentJob.JobDurationJob DurationMicrosoft.SQLServer.2008.AgentJob.JobDurationMicrosoft.SQLServer.2008.AgentJobSystem.Health.PerformanceStatePerformanceCollectionTrue0FalseTrueMicrosoft.SQLServer.2008.AgentLongRunningJobsProviderPerJobTruePublic
Microsoft.SQLServer.2008.AgentJob.JobLastRunStateLast Run StatusMicrosoft.SQLServer.2008.AgentJob.JobLastRunStateMicrosoft.SQLServer.2008.AgentJobSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseTrueMicrosoft.SQLServer.2008.AgentJobLastRunProviderTruePublic
Microsoft.SQLServer.2008.AnalysisServices.ServiceMonitorSQL Server Analysis Services Windows ServiceMicrosoft.SQLServer.2008.AnalysisServices.ServiceMonitorMicrosoft.SQLServer.2008.AnalysisServicesSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2008.Database.Configuration.AutoCloseAuto Close FlagMonitors the auto close flag on the databaseMicrosoft.SQLServer.2008.Database.Configuration.AutoCloseMicrosoft.SQLServer.2008.DatabaseSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2008.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2008.Database.Configuration.AutoCreateStatAuto Create Statistics FlagMonitors the automatically create statistics flag on the databaseMicrosoft.SQLServer.2008.Database.Configuration.AutoCreateStatMicrosoft.SQLServer.2008.DatabaseSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2008.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2008.Database.Configuration.AutoShrinkAuto Shrink FlagMonitors the auto shrink flag on the databaseMicrosoft.SQLServer.2008.Database.Configuration.AutoShrinkMicrosoft.SQLServer.2008.DatabaseSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2008.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2008.Database.Configuration.AutoUpdateSetAuto Update FlagMonitors the auto update flag on the databaseMicrosoft.SQLServer.2008.Database.Configuration.AutoUpdateSetMicrosoft.SQLServer.2008.DatabaseSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2008.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2008.Database.Configuration.DBChainingDB Chaining FlagMonitors the database chaining flag on the databaseMicrosoft.SQLServer.2008.Database.Configuration.DBChainingMicrosoft.SQLServer.2008.DatabaseSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2008.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2008.Database.Configuration.TornPageDetectionTorn Page DetectionMicrosoft.SQLServer.2008.Database.Configuration.TornPageDetectionMicrosoft.SQLServer.2008.DatabaseSystem.Health.ConfigurationStateConfigurationHealthFalse0TrueErrorNormalTrueMicrosoft.SQLServer.2008.DBConfigurationStatusTruePublic
Microsoft.SQLServer.2008.Database.DBSizeMegabytesMonitorDB Space Free (MB) Monitors for the free space left in the database in terms of megabytes.Microsoft.SQLServer.2008.Database.DBSizeMegabytesMonitorMicrosoft.SQLServer.2008.DatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2008.DBAndLogSizeMonitorTypeTruePublic
Microsoft.SQLServer.2008.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.2008.Database.DBSizePercentageChangeMonitorMicrosoft.SQLServer.2008.DatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2008.DBPercentageChangeTruePublic
Microsoft.SQLServer.2008.Database.DBSizePercentMonitorDB Space Free (\%) Monitors for the free space left in the database in percentage terms.Microsoft.SQLServer.2008.Database.DBSizePercentMonitorMicrosoft.SQLServer.2008.DatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2008.DBAndLogSizeMonitorTypeTruePublic
Microsoft.SQLServer.2008.Database.DBStatusMonitorDatabase StatusMicrosoft.SQLServer.2008.Database.DBStatusMonitorMicrosoft.SQLServer.2008.DatabaseSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2008.DBStatusTruePublic
Microsoft.SQLServer.2008.Database.LogShippingDestinationMonitorDestination Log Shipping MonitorMicrosoft.SQLServer.2008.Database.LogShippingDestinationMonitorMicrosoft.SQLServer.2008.DatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.2SingleEventLog2StateMonitorTypeTruePublic
Microsoft.SQLServer.2008.Database.LogShippingSourceMonitorSource Log Shipping Monitor Microsoft.SQLServer.2008.Database.LogShippingSourceMonitorMicrosoft.SQLServer.2008.DatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.2SingleEventLog2StateMonitorTypeTruePublic
Microsoft.SQLServer.2008.Database.TransactionLogSizeMegabytesMonitorTransaction Log Space Free (MB) Monitors for the free space left in the transaction log in percentage terms.Microsoft.SQLServer.2008.Database.TransactionLogSizeMegabytesMonitorMicrosoft.SQLServer.2008.DatabaseSystem.Health.PerformanceStatePerformanceHealthFalse0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2008.DBAndLogSizeMonitorTypeTruePublic
Microsoft.SQLServer.2008.Database.TransactionLogSizePercentMonitorTransaction Log Space Free (\%) Monitors for the free space left in the transaction log in percentage terms.Microsoft.SQLServer.2008.Database.TransactionLogSizePercentMonitorMicrosoft.SQLServer.2008.DatabaseSystem.Health.PerformanceStatePerformanceHealthTrue0TrueMatchMonitorHealthNormalTrueMicrosoft.SQLServer.2008.DBAndLogSizeMonitorTypeTruePublic
Microsoft.SQLServer.2008.DBEngine.BlockedSPIDsMonitorBlocking SPIDsMicrosoft.SQLServer.2008.DBEngine.BlockedSPIDsMonitorMicrosoft.SQLServer.2008.DBEngineSystem.Health.PerformanceStatePerformanceHealthTrue0FalseTrueMicrosoft.SQLServer.2008.DBEngine.BlockedSPIDsTruePublic
Microsoft.SQLServer.2008.DBEngine.Configuration.ServicePackLevelService Pack ComplianceMonitors the service pack level of the database engine against the compliant settingMicrosoft.SQLServer.2008.DBEngine.Configuration.ServicePackLevelMicrosoft.SQLServer.2008.DBEngineSystem.Health.ConfigurationStateConfigurationHealthTrue0TrueErrorNormalTrueMicrosoft.SQLServer.2008.ServicePackVersionTruePublic
Microsoft.SQLServer.2008.DBEngine.FullTextSearchServiceMonitorSQL Server Full Text Search Service MonitorMicrosoft.SQLServer.2008.DBEngine.FullTextSearchServiceMonitorMicrosoft.SQLServer.2008.DBEngineSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2008.DBEngine.ServiceMonitorSQL Server Windows ServiceMicrosoft.SQLServer.2008.DBEngine.ServiceMonitorMicrosoft.SQLServer.2008.DBEngineSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2008.DBEngine.UserConnectionsBaselineMonitorSQL User Connections PerformanceMicrosoft.SQLServer.2008.DBEngine.UserConnectionsBaselineMonitorMicrosoft.SQLServer.2008.DBEngineSystem.Health.PerformanceStatePerformanceHealthFalse0TrueErrorNormalTrueSystem.Performance.TwoStateAboveBaseliningMonitorWithoutCompressionTruePublic
Microsoft.SQLServer.2008.DBFile.DiskFreeSpaceDisk Free SpaceMicrosoft.SQLServer.2008.DBFile.DiskFreeSpaceMicrosoft.SQLServer.2008.DBFileSystem.Health.PerformanceStatePerformanceHealthTrueLogicalDisk\% Free Space3600TrueErrorNormalTrueSystem.Performance.ThresholdMonitorTypeTruePublic
Microsoft.SQLServer.2008.IntegrationServices.ServiceMonitorSQL Server Integration Services Windows ServiceMicrosoft.SQLServer.2008.IntegrationServices.ServiceMonitorMicrosoft.SQLServer.2008.IntegrationServicesSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic
Microsoft.SQLServer.2008.ReportingServices.ServiceMonitorSQL Server Reporting Services Windows ServiceMicrosoft.SQLServer.2008.ReportingServices.ServiceMonitorMicrosoft.SQLServer.2008.ReportingServicesSystem.Health.AvailabilityStateAvailabilityHealthTrue0TrueErrorNormalTrueMicrosoft.Windows.CheckNTServiceStateMonitorTypeTruePublic