Grooming the MOM SCDW (System Center DataWarehouse) database
As you might now, all data which is transfered to the datawarehouse for long-term trend analysis is kept by default for 395 days.
Depending on the number of management packs and events/alerts you are creating, the SCDW database can become quite big...
To change the grooming setting on the SCDW from 395 days to 180 days, you will have to use a stored procedure from SQL Analyser the change those parameters.
There is no graphical interface available from MOM.
So open the SQL Analyzer, switch to the "SystemCenterReporting" database from the database drop-down, and enter the following command
Exec p_updategroomdays 'Table_Name_Here', DaysToRetain
for different tables:
SC_EventParameterFact_Table
SC_AlertFact_Table
SC_SampledNumericDataFact_Table
SC_AlertToEventFact_Table
SC_EventFact_Table
SC_AlertHistoryFact_Table
For more information: Q887016
To initiate the grooming process, run the SQL Server Agent scheduled job "SDCWGroomJob".
To avoid extreme growth of the SCDW, you should really have a look at the MOM 2005 Summary Reporting Pack, which you can download here.