With 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).
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.
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.