Report Portal

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.


Tags: management, performance, tabular


2007-2015 VidasSoft Systems Inc.