This monitor checks the DW DB Alert Staging table row count and generates alert when the row count is over the configured threshold.
This monitor checks if row count of the 'Alert.AlertStage' table in OpsMgr Data Warehouse DB is above configured threshold. Higher row count may indicate performance related issues on the OpsMgr Data Warehouse DB and SQL server.
By default this monitor runs very 15 minutes. In order to fully utilise OpsMgr Cook Down feature, it is sharing the same data source module and its configuration with other staging table row count monitors and performance collection rules. To optimise the performance, when creating overrides for 'Interval Seconds', 'Sync Time' 'SQL Query Timeout Seconds' and 'Script Timeout Seconds' parameters, please make sure same overrides are also created for other staging table row count monitors and performance collection rules.
http://www.bictt.com/blogs/bictt.php/2014/10/10/case-of-the-fast-growing
http://blog.tyang.org/2015/06/11/opsmgr-2012-data-warehouse-health-check-script/
Target | Microsoft.SystemCenter.AllManagementServersPool | ||
Parent Monitor | System.Health.PerformanceState | ||
Category | PerformanceHealth | ||
Enabled | False | ||
Alert Generate | True | ||
Alert Severity | MatchMonitorHealth | ||
Alert Priority | Normal | ||
Alert Auto Resolve | True | ||
Monitor Type | OpsMgr.Self.Maintenance.DW.DB.Staging.Table.Row.Count.2State.Threshold.MonitorType | ||
Remotable | True | ||
Accessibility | Internal | ||
Alert Message |
| ||
RunAs | Default |