Posts Tagged Data Warehouse

Data warehouse debugging

While I was investigating the data warehouse grooming internals, I found a neat debugging feature that can be turned on to check the internals of DW stored procedures. In the dbo.StandardDataSet table, for every dataset, there’s a DebugLevel column. By default its value is 0 or no debugging info at all. The higher the value […]

, ,

Leave a comment

SCOM Data Warehouse grooming

So my data warehouse has reached the 150 GB size limit and it’s time to check if everything’s ok. Not that this size is too much, with about 300 agents and 170 MPs in production this is not huge. Nevertheless I learned not to be too confident on OpsMgr reliability and I don’t want my […]

, ,