Analysis Services Tabular or Multidimensional? A performance comparison
Can SSAS Multidimensional be faster than SSAS Tabular for distinct counts on large datasets? We've all seen how fast the SSAS Tabular model can work - it's an in-memory, heavily compressed analytics database. However you may have seen my previous posts on Tabular and NUMA, which show that at the moment Tabular is limited to a single CPU. This obviously limits its scalability and maximum performance.
Read more...Tags: management, performance, tabular