Update (06/07/2015). As a few people have pointed out this is more of a named instance issue than a “tabular” specific issue. I added some details on how to optimise SSAS connections here http://blogs.prodata.ie/post/Optimising-Connections-to-SSAS-(MOLAPTabular).aspx http://blogs.prodata.ie/post/Solved-slow-SSAS-connections-on-Hyper-V.aspx -- original post ------------------------------------------------------------------------------------------------------ Seasoned developers are often shocked when they find out the SSAS doesn't have any support for connection pooling. … Continue reading How connections will hurt your Tabular Workload
Tag: Tabular
There are generally three reasons for partitioning an Analysis Services model: To improve processing time by running partitioning in parallelTo improve processing time by allowing for incremental processing of some sortTo improve query time where most queries only need a smaller slice of data – say a week or month. To help test this I … Continue reading Be Careful Partitioning Analysis Services (Tabular)