BI performance counter: Total queries answered

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

  1. Try using the Query Log server settings and save queries to a database table automatically
  2. Use SQL Server Profiler to see what queries get sent to the server
  3. 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

 

To track BI performance metrics – consider using ApexSQL BI Monitor, a web application that monitors system, SSAS, SSIS and SSRS performance in real time.

⇐ Back to index