Applies to
SSAS
Description
This performance counter relates to the measurement of Analysis Services storage engine queries. It monitors the total number of dimension queries that were processed since the restart of the Analysis Services instance. Preferably the source for these dimension queries should be the memory cache instead of retrieving the data from the disk.
Resolved by
DBAs, Server administrators, BI developers
Suggested solutions
- Use Extended Events to monitor dimension query processing
- Try to use faster storage (SSD) or more disk drives for quicker responses to Storage Engine requests
- Optimize the data types of fields used by Analysis Services at the source database
Additional research
Identify Storage Engine and Formula Engine bottlenecks with new SSAS XEvents
Performance Counters (SSAS)
Formula engine and storage engine in SSAS