Resetting and running the Service Manager Data Warehouse Jobs separately

We can see quite some issues with running the SM Data Warehouse Jobs or finishing the Cube Processing Jobs. Most of these issues are related to performance problems due to down-sizing of the hardware on the SM Data Warehouse server, SQL Server with the DW databases and/or SQL Server with the SQL Analysis Services. So…

4

How to manually delete a data set from the Data Warehouse in OM 2007 R2

IMPORTANT: Always perform a FULL Backup of the databases before doing anything to it !!! ALSO: It is advised that you open a case at Microsoft before doing this – directly editing the database is not supported and you may find yourself in an unsupported state if anything goes wrong.   If by any chance you run…

1

Cleaning up old data from the Data Warehouse database in OM 2007 R2

IMPORTANT: Allways perform a FULL Backup of the databases before doing anything to it !!!   There are some situations like event storms where you end up havin old entries in the OM 2007 Data Warehouse database. Old data as in data that is older than the grooming threshold. This may happen because if you…

0