Настройки памяти

SQL Server 2005 Analysis Services Memory Configurations

Memory configuration in SQL Server 2005 Database Engines

Очистка кеша
DBCC FREESYSTEMCACHE ('ALL')
DBCC FREEPROCCACHE;
DBCC DROPCLEANBUFFERS