Real world problems with good old SCOM 2012 R2
IMPORTANT: Always perform a FULL Backup of the database before doing anything to it !!!
This article applies to SCOM 2007 and SCOM 2012
Somtimes you may have event storms where you end up having old entries in the Data Warehouse database i.e data that is older than the grooming threshold. This may happen beacuse the grooming processes can’t keep up because they run on a regular interval but only delete a fixed number of rows per run.
The following SQL query may also be valuable in case you end up with the issue of SQL Timeouts from the Data Warehouse database when the StandardDataSetMaintenance stored procedure is executed by the RMS.
To check if this is the case for you, run this SQL Query on the Data Warehouse database:
DECLARE @MaxDataAgeDays INT, @DataSetName NVARCHAR(150) SET @DataSetName = ‘Event’ SELECT @MaxDataAgeDays = MAX(MaxDataAgeDays) FROM StandardDatasetAggregation WHERE DatasetId =…
View original post 221 more words