I’ve been diving deep into how long Analysis Services can take to open a connection for a few months now and thanks to some tips from many people (Alberto Ferrari, Greg Galloway, Darren Gospel to name a few) here are some ideas to improve performance. 1. Make sure your network is not slow OK, sounds … Continue reading Optimising Connections to SSAS (MOLAP/Tabular)
Category: BI
Over the last few months we have been developing reporting services reports on top of a SSAS tabular model. One of the banes of my life has been the unusable performance of our reports, especially if they open a lot of connections. This week I finally got some time to triage the issue and found … Continue reading Solved: slow SSAS connections on Hyper-V