http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/maintain/optimize/ANSvcsPG.asp Summary: This paper describes techniques you can use to optimize query responsiveness and processing performance in Microsoft® SQL Server™ 2000 Analysis Services. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.