SSAS Data Directory maintenance
By default, all of the files used by Analysis Services to store MOLAP data are stored in the Analysis Services data directory. The location of this directory is set up during installation, and can be changed by setting the value of the DataDir server property.
As with any other type of file handled by Windows, the files in the Analysis Services data directory are prone to fragmentation. During processing, many files are created, written, and deleted. If the disk is very fragmented, these files may be split across different portions of the disk, slowing down access to them.
A regular defragmentation of the drive on which the data directory exists will improve the overall speed of the disk subsystem, which will of course ...
Get Expert Cube Development with SSAS Multidimensional Models now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
