The MSSQL Analysis Memory Layer

Using the tests mapped to this layer, the following can be performed:

  • The usage of the aggregation cache can be tracked, and poor cache hit ratios revealed;

  • Deadlock conditions and abnormally long lock waits are brought to the attention of administrators;

  • MDX query performance can be measured, and factors impacting the same can be isolated;

  • Memory usage of SSAS can be tracked, and inadequate memory allocation to SSAS can be captured;

Figure 1 : The tests mapped to the MSSQL Analysis Memory layer