Performance Tuning and Troubleshooting Tabular Models - SQL Server Analysis Services 2012 Cube Development - page 406

BISM server memory report
One very good example and useful application of this DMV is in an Excel workbook
created by Kasper de Jonge from the Analysis Services product team at Microsoft.
This workbook contains a Power Pivot model that runs a simple query, similar to the
previous example, to populate a table with calculations used to analyze the memory
usage of various database objects in comparison to other objects. The results are
displayed in Excel PivotTables with conditional formatting to proportionally highlight
larger objects as shown in the following screenshot:
You can get more information and download the from Kasper's blog at ht-
tp://www.PowerPivotblog.nl/what-is-using-all-that-memory-on-my-analysis-server-
instance . Keep in mind that this is a simple application and just one of the many use-
ful DMVs; this DMV returns approximated values that can be affected by different
factors, but it does provide useful information for quick and easy problem solving.