SQL Server 2012: Analysis Services tabular model memory consumption

imageWith SQL Server 2012 Microsoft introduces the new in-memory analytics engine “xVelocity”. This new engine is delivered within the following modules:

xVelocity for Data Warehousing: is a memory optimized columnstore index for high speed data querying (relational queries).

xVelocity for Business Intelligence: is the in-memory analytics engine for Analysis Services (Tabular Model) and PowerPivot.

As the name in-memory engine implies all the data is stored in memory. Although todays computer systems are equipped with gigabytes of memory, memory still is an expensive resource. Therefore we need to be able to analyze the memory usage of the Analysis Services in-memory engine to understand how much memory is consumed by the different applications.

Kasper de Jonge did exactly this and created a PoverPivot workbook that allows to investigate the memory usage.

image

The workbook uses an MDX statement to query the memory information from Analysis Services as shown below.

select * from $system.Discover_object_memory_usage

The workbook can be downloaded here: BISMServerMemoryReport.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s