September 20, 2012 at 10:50 am
Greetings all 😀
So I have been having a bit of performance issues with my company's data cubes as of late. Not with the cubes themselves per se, but multiple concurrent connections. The problem is, some users have workbooks with 30+ cubes in them. Short of slapping the hands of each user and giving new rules (which I would have no idea how to enforce!), are there any intuitive ways of handling this?
Link to my blog http://notyelf.com/
October 12, 2012 at 9:10 am
I experienced this when we move to use XLCubed (an excellent OLAP tool BTW).
What I did was alter a couple of SSAS setting
I increased the # of query max threads
I also set IdleConnectionTimeout from 0 to 36000. This means that people who leave Excel open get disconnected after 10 hours of inactivity rather than waiting for them to close Excel (accountants never do this voluntarily). All that happens the following day is they have to reconnect – it’s no biggie and I don’t get complaints about it
Mack
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply