How it is build: the SSAS memory report

So recently I created a new SSAS memory report that you can use to analyze the memory usage of your SSAS servers, read more on the actual report here. In this blog post we’ll look at how this report was build.

First let’s look at what is needed for us to get the information we need for tabular models with compatibility level 1200 or higher. The most detailed information for the tabular model we can get by querying the DMV DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS. This will give us plenty of data to work with like:

Read more...