February 19, 2014 at 6:33 pm
how to perform below maintenance tasks on analysis databases?
1. Index defrag
2. Integrity check - DBCC CHECKDB
3. Update statistics
Thanks
February 20, 2014 at 12:48 pm
Is it possible to perform above maintenance tasks on Analysis databases or not? Please advise.
February 20, 2014 at 7:15 pm
Mani-584606 (2/19/2014)
how to perform below maintenance tasks on analysis databases?1. Index defrag
2. Integrity check - DBCC CHECKDB
3. Update statistics
Thanks
These tasks are not relevant to analysis services databases. The way analysis services manages data is nothing like a relational database.
Simplistically, analysis services rebuilds the parts of the cube that are being loaded so there is really no need to worry so much about defragging and updating stats.
As for DBCC CHECKDB - I have never seen a corruption since I have been using Analysis Services (and OLAP Services before that). Maybe I have been lucky. If a corruption occurs, after taking appropriate steps to ensure that the underlying error is corrected, re-processing the cube should get you back up and running - after all, the cube is typically not the primary source of data. It is normally a copy of data stored in another database (e.g. SQL Server)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply