O'Reilly logo

Microsoft Tabular Modeling Cookbook by Paul te Braak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating and managing partitions

The tabular model is an in-memory engine meaning that the data in the model (all models on the tabular server) is compressed and stored in the RAM while the server is running. The tabular server also stores data on the disk (storage for when the SSAS engine is not running)—however, the rule is generally that all queries against the model are performed on cached data. The exception to this, of course, is when there is not enough RAM for the engine to use, and paging occurs.

This is a stark contrast to Multidimensional Online Analytical Processing (MOLAP) storage, which stores data on the disk (notwithstanding aggregations that may have been cached). This storage requires an effective partitioning strategy as a performance ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required