Analysis Services, Microsofts OLAP and Data Mining engine, is a very powerful tool. But like many powerfull tools, if you don't configure it in the right way, it impacts the performance. There are a bunch of 'best practises', but now there is also a tool which automatically checks these.
Analysis Services Best Practise Analyser
checks your live OLAP databases against some key Best practises. Currently, it checks for aggregations, attribute relationships and non-empty behavior on calculations, but we plan to add more in the future. Try it out for free!