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