Hello everyone , I have been asked to go through Analysis Services databases in development server and see how can i improve the performance of the database ? Any ideas on this folks ? any link or even some advice will be helpful , as i m not able to understand where to start from as i am new to analysis services concept. Thanks in advance Yukon DBA
Hi, I haven't worked in AS but here are some referrence I found, though this may help you http://download.microsoft.com/downl...-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc http://support.microsoft.com/kb/327396 and some AS performance tunning article on our very own SSP http://www.sql-server-performance.com/articles/biz/index.aspx