Engaging the Formula Engine Cache with SSAS Tabular
One of the more subtle architectural differences between tabular and multidimensional instances is caching.
Multidimensional is a disk-based technology and performance for query workloads (in many cases) depends heavily on cache utilization. Tabular, on the other hand, is a memory-based technology with (nearly) zero dependence on disk IO and is therefore much less dependent on cache for query workload performance.
Tags: performance, tabular