Chapter 9. Understanding xVelocity and DirectQuery

In the first chapters of this book, you learned what a Tabular model is, how to build and query a Tabular model, and how to use DAX to implement more advanced calculations. Now you take a look at the internal engine of a Tabular model. This knowledge can affect the way you model your data to optimize memory consumption and overall performance.

In this chapter, you discover the internal architecture of Analysis Services 2012 for Tabular models. You can deploy a Tabular model by choosing between the In-Memory mode (xVelocity in-memory analytics engine, also known as VertiPaq) and the Microsoft SQL Server–based mode (DirectQuery). (Because the xVelocity name has been introduced late in the development ...

Get Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.