Applies to
SSAS
Description
This performance counter relates to the measurement of Analysis Services storage engine queries. It measures the total number of queries derived directly from a memory cache since Analysis Services service was restarted. This is measured per partition.
Resolved by
DBAs, Server administrators, BI developers
Suggested solutions
- Optimize the data types of fields used by Analysis Services at the source database
- Reduce Data type conversions
- Use DMVs to monitor processing activity through i.e. find out what objects are consuming the most memory and CPU
Additional research
Analysis Services 2005 – Performance Counter Guidance
Performance Counters (SSAS)
Formula engine and storage engine in SSAS
See more
Check out SpotLight, a free, cloud based SQL Server monitoring tool to easily detect, monitor, and solve SQL Server performance problems on any device