Optimizing File Locations for Analysis Services 2005

  • Article

The following techniques can help you to optimize the data files and temporary files used during processing:

 

· Place the Analysis Services data files on a fast disk subsystem.

     The location of the data files is determined by the DataDir server property. To optimize disk access for querying and processing, place the Analysis Services Data folder on a dedicated disk subsystem (RAID 5, RAID 1+0, or RAID 0+1).

· If temporary files are used during processing, optimize temporary file disk I/O.

     The default location of the temporary files created during aggregation processing is controlled by the TempDir property. If a temporary file is used, you can increase processing performance by placing this temporary folder on a fast disk subsystem (such as RAID 0 or RAID 1+0) that is separate from the data disk.