Tag Archives: Data Warehouse

OpsMgrDW Grooming

After a while my demo environment with OpsMgr data warehouse (and loads of other stuff) needed some more space. I haven’t looked in to grooming of the DW before. So as usual Google is a nice friend. 🙂 Stefan Stranger … Continue reading

Posted in OpsMgr | Tagged , , | Comments Off on OpsMgrDW Grooming

Uppdatera GroomDays i SCDW

För att minska ner storleken på SystemCenterReporting-databasen kan man dra ner på antalet dagar man sparar data. Genom att köra det här SQL-scriptet så drar man ner till 7 dagar. USE SystemCenterReporting Declare @Groomdays int Select @Groomdays=7 exec p_updateGroomDays ‘SC_SampledNumericDataFact_Table’, … Continue reading

Posted in MOM2005, SQL Server | Tagged , , | Comments Off on Uppdatera GroomDays i SCDW