Side effects of storing an Analysis Services partition data in a non-default location
In 2005 and 2008, SQL Server Analysis Services allows users to store partition data in a non-default location. That is something we could not do in 2000 version. To store a partition data in a non-default location means that you can have the partition storage location set to some folder other than the default data folder (see the screen shot below). Some users choose to use the feature because it can off load some IO to different drives. It helps balancing IO activities. Others choose to use it simply because they don’t have enough disk space in the default location.
Tags: partition, management