OpsMgr Self Maintenance Check Data Warehouse Database Daily Aggregation 3-State Monitor

OpsMgr.Self.Maintenance.Check.Data.Warehouse.DB.Daily.Aggregation.Count.3State.Monitor (UnitMonitor)

Monitors the DW DB Daily data set aggregation process.

Knowledge Base article:

Summary

This mornitor runs on a schedule and check for number of DW standard data sets that are waiting to be aggregated (aggregation type: Daily). This monitor is adopted from Michel Kamp's blog post: http://michelkamp.wordpress.com/2013/03/24/get-a-grip-on-the-dwh-aggregations/

Configuration

By default, this monitor runs hourly and has 2 thresholds. The default warning threshold is configured to 4 and critical threshold is configured to 10.

Causes

There are several possible causes for this monitor to become unhealthy. more information can be found from this article: http://blogs.technet.com/b/operationsmgr/archive/2011/09/06/standard-dataset-maintenance-troubleshooter-for-system-center-operations-manager-2007.aspx

Resolutions

Please follow the instructions from this article: http://michelkamp.wordpress.com/2012/03/23/dude-where-my-availability-report-data-from-the-scom-dwh/

Additional

http://michelkamp.wordpress.com/2012/04/10/scom-dwh-aggregations-data-loose-tip-and-tricks/

Element properties:

TargetMicrosoft.SystemCenter.DataWarehouse.DataSet
Parent MonitorSystem.Health.PerformanceState
CategoryPerformanceHealth
EnabledFalse
Alert GenerateTrue
Alert SeverityMatchMonitorHealth
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeOpsMgr.Self.Maintenance.Check.DW.DB.Aggregation.Count.3State.Monitor.Type
RemotableTrue
AccessibilityPublic
Alert Message
OpsMgr Data Warehouse DB is having trouble aggregating Daily data set
The number of Daily datasets waiting to be aggregated is above configured threshold. Please refer to the alert context for more details.
RunAsDefault