Applies to
SSAS
Description
This performance counter relates to the measurement of Analysis Services storage engine queries. It monitors the total number of queries that were run against Analysis Services since the service was restarted.
The counter includes queries answered directly from the memory cache as well as from files. If this number does not increase, then no queries are being run against your instance. For details of the queries being rendered, you can trace the Query End event in SQL Server Profiler.
Resolved by
DBAs, Server administrators, BI developers
Suggested solutions
- Try using the Query Log server settings and save queries to a database table automatically
- Use SQL Server Profiler to see what queries get sent to the server
- Try to use faster storage (SSD) or more disk drives for quicker responses to Storage Engine requests
Additional research
Counting Number of Queries Executed in SSAS
Performance Counters (SSAS)
Formula engine and storage engine in SSAS