SCOM – Out of the Box Monitor Thresholds

Target DisplayName Enabled Threshold Frequency Samples Counter Object
SQL Server 2005 Agent Agent job availability (rollup) TRUE
SQL Server 2005 Agent Agent job performance (rollup) TRUE
SQL Server 2005 Agent Long Running Jobs FALSE first threshold is: 60 second threshold is: 120
SQL Server 2005 Agent SQL Server Agent Windows Service TRUE
SQL Server 2005 Agent Job Job Duration TRUE first threshold is: 60 second threshold is: 120
SQL Server 2005 Agent Job Last Run Status TRUE
SQL Server 2005 Analysis Services SQL Server Analysis Services Windows Service TRUE
SQL Server 2005 DB Auto Close Configuration FALSE
SQL Server 2005 DB Auto Create Statistics Configuration FALSE
SQL Server 2005 DB Auto Shrink Configuration FALSE
SQL Server 2005 DB Auto Update Statistics Async Configuration FALSE
SQL Server 2005 DB Auto Update Statistics Configuration FALSE
SQL Server 2005 DB Automatic Configuration TRUE
SQL Server 2005 DB Database Status TRUE
SQL Server 2005 DB DB Chaining Configuration FALSE
SQL Server 2005 DB DB File Group Space (rollup) TRUE
SQL Server 2005 DB DB Log File Space TRUE
SQL Server 2005 DB DB Log File Space (rollup) TRUE
SQL Server 2005 DB DB Log File Space Free (%) : DEPRECATED FALSE first threshold is: 10 second threshold is: 20 Log Free Space (%) $Target/Host/Property[Type=”SQL!Microsoft.SQLServer.DBEngine”]/PerformanceCounterObject$:TransactionLog
SQL Server 2005 DB DB Log File Space Free (MB) : DEPRECATED FALSE first threshold is: -1 second threshold is: -1 Log Free Space (MB) $Target/Host/Property[Type=”SQL!Microsoft.SQLServer.DBEngine”]/PerformanceCounterObject$:TransactionLog
SQL Server 2005 DB DB Space TRUE
SQL Server 2005 DB DB Space Free (MB) : DEPRECATED FALSE first threshold is: -1 second threshold is: -1 DB Total Free Space (MB) $Target/Host/Property[Type=”SQL!Microsoft.SQLServer.DBEngine”]/PerformanceCounterObject$:Database
SQL Server 2005 DB DB Space Percentage Change FALSE first threshold is: 25 second threshold is: 45 5 DB Total Free Space (%) $Target/Host/Property[Type=”SQL!Microsoft.SQLServer.DBEngine”]/PerformanceCounterObject$:Database
SQL Server 2005 DB DB Total Space FALSE first threshold is: 10 second threshold is: 20 DB Total Free Space (%) $Target/Host/Property[Type=”SQL!Microsoft.SQLServer.DBEngine”]/PerformanceCounterObject$:Database
SQL Server 2005 DB Destination Log Shipping TRUE
SQL Server 2005 DB External Access Configuration TRUE
SQL Server 2005 DB Page Verify Configuration FALSE
SQL Server 2005 DB Recovery Configuration TRUE
SQL Server 2005 DB Recovery Model Configuration FALSE
SQL Server 2005 DB Source Log Shipping TRUE
SQL Server 2005 DB SQL Server Windows Service TRUE 60
SQL Server 2005 DB Trustworthy Configuration FALSE
SQL Server 2005 DB Engine Blocking Sessions FALSE
SQL Server 2005 DB Engine Database Performance (rollup) TRUE
SQL Server 2005 DB Engine Service Pack Compliance TRUE
SQL Server 2005 DB Engine SQL Server Full Text Search Service FALSE
SQL Server 2005 DB Engine SQL Server Windows Service TRUE 60
SQL Server 2005 DB Engine SQL User Connections Performance FALSE no threshold (baseline monitor)
SQL Server 2005 DB File DB File Space TRUE first threshold is: 10 second threshold is: 20 DB File Free Space (%) $Target/Host/Host/Host/Property[Type=”SQL!Microsoft.SQLServer.DBEngine”]/PerformanceCounterObject$ : Database : DB File
SQL Server 2005 DB File Disk Free Space : DEPRECATED FALSE 5 3600 % Free Space LogicalDisk
SQL Server 2005 DB File Group DB File Group Space TRUE
SQL Server 2005 DB File Group DB File Space (rollup) TRUE
SQL Server 2005 DB Log File DB Log File Space TRUE first threshold is: 10 second threshold is: 20 DB Log File Free Space (%) $Target/Host/Host/Property[Type=”SQL!Microsoft.SQLServer.DBEngine”]/PerformanceCounterObject$ : Database : DB File
SQL Server 2005 Distributor Database Availability (rollup) TRUE
SQL Server 2005 Distributor Database Performance (rollup) TRUE
SQL Server 2005 Integration Services SQL Server Integration Services Windows Service TRUE
SQL Server 2005 Reporting Services SQL Server Reporting Services Windows Service TRUE
SQL Server 2008 Agent Agent job availability (rollup) TRUE
SQL Server 2008 Agent Agent job performance (rollup) TRUE
SQL Server 2008 Agent Long Running Jobs FALSE first threshold is: 60 second threshold is: 120
SQL Server 2008 Agent SQL Server Agent Windows Service TRUE
SQL Server 2008 Agent Job Job Duration TRUE first threshold is: 60 second threshold is: 120
SQL Server 2008 Agent Job Last Run Status TRUE
SQL Server 2008 Analysis Services SQL Server Analysis Services Windows Service TRUE
SQL Server 2008 DB Auto Close Configuration FALSE
SQL Server 2008 DB Auto Create Statistics Configuration FALSE
SQL Server 2008 DB Auto Shrink Configuration FALSE
SQL Server 2008 DB Auto Update Statistics Async Configuration FALSE
SQL Server 2008 DB Auto Update Statistics Configuration FALSE
SQL Server 2008 DB Automatic Configuration TRUE
SQL Server 2008 DB Database Backup Status FALSE 7
SQL Server 2008 DB Database Status TRUE
SQL Server 2008 DB DB Chaining Configuration FALSE
SQL Server 2008 DB DB File Group Space (rollup) TRUE
SQL Server 2008 DB DB Log File Space TRUE
SQL Server 2008 DB DB Log File Space (rollup) TRUE
SQL Server 2008 DB DB Log File Space Free (%) FALSE first threshold is: 10 second threshold is: 20 Log Free Space (%) $Target/Host/Property[Type=”SQL!Microsoft.SQLServer.DBEngine”]/PerformanceCounterObject$:TransactionLog
SQL Server 2008 DB DB Log File Space Free (MB) : DEPRECATED FALSE first threshold is: -1 second threshold is: -1 Log Free Space (MB) $Target/Host/Property[Type=”SQL!Microsoft.SQLServer.DBEngine”]/PerformanceCounterObject$:TransactionLog
SQL Server 2008 DB DB Space TRUE
SQL Server 2008 DB DB Space Free (MB) : DEPRECATED FALSE first threshold is: -1 second threshold is: -1 DB Free Space (MB) $Target/Host/Property[Type=”SQL!Microsoft.SQLServer.DBEngine”]/PerformanceCounterObject$:Database
SQL Server 2008 DB DB Space Percentage Change FALSE first threshold is: 25 second threshold is: 45 5 DB Total Free Space (%) $Target/Host/Property[Type=”SQL!Microsoft.SQLServer.DBEngine”]/PerformanceCounterObject$ : Database
SQL Server 2008 DB DB Total Space FALSE first threshold is: 10 second threshold is: 20 DB Total Free Space (%) $Target/Host/Property[Type=”SQL!Microsoft.SQLServer.DBEngine”]/PerformanceCounterObject$:Database
SQL Server 2008 DB Destination Log Shipping TRUE
SQL Server 2008 DB Disk Read Latency FALSE 40 6
SQL Server 2008 DB Disk Write Latency FALSE 25 6
SQL Server 2008 DB External Access Configuration TRUE
SQL Server 2008 DB Page Verify Configuration FALSE
SQL Server 2008 DB Recovery Configuration TRUE
SQL Server 2008 DB Recovery Model Configuration FALSE
SQL Server 2008 DB Source Log Shipping TRUE
SQL Server 2008 DB SQL Server Windows Service TRUE 60
SQL Server 2008 DB Trustworthy Configuration FALSE
SQL Server 2008 DB Engine Average Wait Time TRUE 250 6 $Target/Property[Type=”SQL!Microsoft.SQLServer.DBEngine”]/PerformanceCounterObject$:Locks
SQL Server 2008 DB Engine Blocking Sessions FALSE
SQL Server 2008 DB Engine Buffer Cache Hit Ratio TRUE 0
SQL Server 2008 DB Engine CPU Utilization (%) TRUE 95 6
SQL Server 2008 DB Engine Database Performance (rollup) TRUE
SQL Server 2008 DB Engine Page Life Expectancy TRUE 300
SQL Server 2008 DB Engine Service Pack Compliance TRUE
SQL Server 2008 DB Engine Service Principal Name Configuration Status TRUE
SQL Server 2008 DB Engine SQL Re-Compilation FALSE 25 6
SQL Server 2008 DB Engine SQL Server Full Text Search Service FALSE
SQL Server 2008 DB Engine SQL Server Windows Service TRUE 60
SQL Server 2008 DB Engine SQL User Connections Performance FALSE no threshold (baseline monitor)
SQL Server 2008 DB Engine Stolen Server Memory TRUE 70 6
SQL Server 2008 DB Engine Thread Count TRUE 6
SQL Server 2008 DB File DB File Space TRUE first threshold is: 10 second threshold is: 20 DB File Free Space (%) $Target/Host/Host/Host/Property[Type=”SQL!Microsoft.SQLServer.DBEngine”]/PerformanceCounterObject$ : Database : DB File
SQL Server 2008 DB File Disk Free Space : DEPRECATED FALSE 5 3600 % Free Space LogicalDisk
SQL Server 2008 DB File Group DB File Group Space TRUE
SQL Server 2008 DB File Group DB File Space (rollup) TRUE
SQL Server 2008 DB Log File DB Log File Space TRUE first threshold is: 10 second threshold is: 20 DB Log File Free Space (%) $Target/Host/Host/Property[Type=”SQL!Microsoft.SQLServer.DBEngine”]/PerformanceCounterObject$ : Database : DB File
SQL Server 2008 Distributor Database Availability (rollup) TRUE
SQL Server 2008 Distributor Database Performance (rollup) TRUE
SQL Server 2008 Integration Services SQL Server Integration Services Windows Service TRUE
SQL Server 2008 Reporting Services SQL Server Reporting Services Windows Service TRUE
SQL 2008 Mirrored DB Database Mirror Status TRUE
SQL 2008 Mirrored DB Database Mirror Witness Status TRUE
SQL 2008 Mirrored DB Witness Database Mirroring Partners Status TRUE
SQL 2008 Mirroring Group Mirrored Database Availability Rollup TRUE
SQL 2008 Mirroring Group Mirrored Database Configuration Rollup TRUE
SQL 2008 Mirroring Group Mirrored Database Performance Rollup TRUE
SQL 2008 Mirroring Group Mirroring Witness Availability Rollup TRUE
SQL 2008 Mirroring Witness Role Mirroring Witness Availability Rollup TRUE
Database Critical Policy Database Health Policy TRUE
Database Warning Policy Database Health Policy TRUE
SQL Server 2012 Agent Agent job availability (rollup) TRUE
SQL Server 2012 Agent Agent job performance (rollup) TRUE
SQL Server 2012 Agent Long Running Jobs FALSE first threshold is: 60 second threshold is: 120
SQL Server 2012 Agent SQL Server Agent Windows Service TRUE
SQL Server 2012 Agent Job Job Duration TRUE first threshold is: 60 second threshold is: 120
SQL Server 2012 Agent Job Last Run Status TRUE
SQL Server 2012 Analysis Services SQL Server Analysis Services Windows Service TRUE
SQL Server 2012 DB Auto Close Configuration FALSE
SQL Server 2012 DB Auto Create Statistics Configuration FALSE
SQL Server 2012 DB Auto Shrink Configuration FALSE
SQL Server 2012 DB Auto Update Statistics Async Configuration FALSE
SQL Server 2012 DB Auto Update Statistics Configuration FALSE
SQL Server 2012 DB Automatic Configuration TRUE
SQL Server 2012 DB Database Backup Status FALSE 7
SQL Server 2012 DB Database Critical Policies TRUE
SQL Server 2012 DB Database Extended Health State TRUE
SQL Server 2012 DB Database Status TRUE
SQL Server 2012 DB Database Warning Policies TRUE
SQL Server 2012 DB DB Chaining Configuration FALSE
SQL Server 2012 DB DB File Group Space (rollup) TRUE
SQL Server 2012 DB DB Log File Space TRUE
SQL Server 2012 DB DB Log File Space (rollup) TRUE
SQL Server 2012 DB DB Space TRUE
SQL Server 2012 DB DB Space Percentage Change FALSE first threshold is: 25 second threshold is: 45 5 DB Total Free Space (%) $Target/Host/Property[Type=”SQL!Microsoft.SQLServer.DBEngine”]/PerformanceCounterObject$:Database
SQL Server 2012 DB DB Total Space FALSE first threshold is: 10 second threshold is: 20 DB Total Free Space (%) $Target/Host/Property[Type=”SQL!Microsoft.SQLServer.DBEngine”]/PerformanceCounterObject$:Database
SQL Server 2012 DB Destination Log Shipping TRUE
SQL Server 2012 DB Disk Read Latency FALSE 40 6
SQL Server 2012 DB Disk Write Latency FALSE 25 6
SQL Server 2012 DB External Access Configuration TRUE
SQL Server 2012 DB Page Verify Configuration FALSE
SQL Server 2012 DB Recovery Configuration TRUE
SQL Server 2012 DB Recovery Model Configuration FALSE
SQL Server 2012 DB Source Log Shipping TRUE
SQL Server 2012 DB SQL Server Windows Service TRUE 60
SQL Server 2012 DB Transaction Log Free Space (%) FALSE 10 Log Free Space (%) $Target/Host/Property[Type=”SQL!Microsoft.SQLServer.DBEngine”]/PerformanceCounterObject$:TransactionLog
SQL Server 2012 DB Trustworthy Configuration FALSE
SQL Server 2012 DB Engine Average Wait Time TRUE 250 6 $Target/Property[Type=”SQL!Microsoft.SQLServer.DBEngine”]/PerformanceCounterObject$:Locks
SQL Server 2012 DB Engine Blocking Sessions FALSE
SQL Server 2012 DB Engine Buffer Cache Hit Ratio TRUE 0
SQL Server 2012 DB Engine CPU Utilization (%) TRUE 95 6
SQL Server 2012 DB Engine Database Performance (rollup) TRUE
SQL Server 2012 DB Engine Page Life Expectancy TRUE 300
SQL Server 2012 DB Engine Service Pack Compliance TRUE
SQL Server 2012 DB Engine Service Principal Name Configuration Status TRUE
SQL Server 2012 DB Engine SQL Re-Compilation FALSE 25 6
SQL Server 2012 DB Engine SQL Server Full Text Search Service FALSE
SQL Server 2012 DB Engine SQL Server Windows Service TRUE 60
SQL Server 2012 DB Engine SQL User Connections Performance FALSE no threshold (baseline monitor)
SQL Server 2012 DB Engine Stolen Server Memory TRUE 70 6
SQL Server 2012 DB Engine Thread Count TRUE 6
SQL Server 2012 DB File DB File Space TRUE first threshold is: 10 second threshold is: 20 DB File Free Space (%) $Target/Host/Host/Host/Property[Type=”SQL!Microsoft.SQLServer.DBEngine”]/PerformanceCounterObject$ : Database : DB File
SQL Server 2012 DB File Group DB File Group Space TRUE
SQL Server 2012 DB File Group DB File Space (rollup) TRUE
SQL Server 2012 DB Log File DB Log File Space TRUE first threshold is: 10 second threshold is: 20 DB Log File Free Space (%) SQL DB Log File
SQL Server 2012 Distributor Database Availability (rollup) TRUE
SQL Server 2012 Distributor Database Performance (rollup) TRUE
SQL Server 2012 Integration Services SQL Server Integration Services Windows Service TRUE
SQL Server 2012 Reporting Services SQL Server Reporting Services Windows Service TRUE
Availability Group Availability Group Automatic Failover TRUE
Availability Group Availability Group Extended Health State TRUE
Availability Group Availability Group Online TRUE
Availability Group Availability Replicas Connection TRUE
Availability Group Availability Replicas Data Synchronization TRUE
Availability Group Availability Replicas Role TRUE
Availability Group Synchronous Replicas Data Synchronization TRUE
Availability Group WSFC Cluster TRUE
Availability Group Critical Policy Availability Group Health Policy TRUE
Availability Group Health Availability Group Automatic Failover monitor TRUE
Availability Group Health Availability Group Critical Policies TRUE
Availability Group Health Availability Group Extended Health State TRUE
Availability Group Health Availability Group Online monitor TRUE
Availability Group Health Availability Group Warning Policies TRUE
Availability Group Health Availability Replicas Connection monitor TRUE
Availability Group Health Availability Replicas Data Synchronization monitor TRUE
Availability Group Health Availability Replicas Role monitor TRUE
Availability Group Health Synchronous Replicas Data Synchronization monitor TRUE
Availability Group Health WSFC Cluster monitor TRUE
Availability Group Warning Policy Availability Group Health Policy TRUE
Availability Replica Availability Replica Connection TRUE
Availability Replica Availability Replica Critical Policies TRUE
Availability Replica Availability Replica Data Synchronization TRUE
Availability Replica Availability Replica Extended Health State TRUE
Availability Replica Availability Replica Join State TRUE
Availability Replica Availability Replica Role TRUE
Availability Replica Availability Replica Warning Policies TRUE
Availability Replica Critical Policy Availability Replica Health Policy TRUE
Availability Replica Warning Policy Availability Replica Health Policy TRUE
Database Replica Availability Database Data Synchronization TRUE
Database Replica Availability Database Join State TRUE
Database Replica Availability Database Suspension State TRUE
Database Replica Database Replica Critical Policies TRUE
Database Replica Database Replica Extended Health State TRUE
Database Replica Database Replica Warning Policies TRUE
Database Replica Critical Policy Database Replica Health Policy TRUE
Database Replica Warning Policy Database Replica Health Policy TRUE
SQL 2012 Mirrored DB Database Mirror Status TRUE
SQL 2012 Mirrored DB Database Mirror Witness Status TRUE
SQL 2012 Mirrored DB Witness Database Mirroring Partners Status TRUE
SQL 2012 Mirroring Group Mirrored Database Availability Rollup TRUE
SQL 2012 Mirroring Group Mirrored Database Configuration Rollup TRUE
SQL 2012 Mirroring Group Mirrored Database Performance Rollup TRUE
SQL 2012 Mirroring Group Mirroring Witness Availability Rollup TRUE
SQL 2012 Mirroring Witness Role Mirroring Witness Availability Rollup TRUE

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: