BI performance counter: Total dimension queries

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

  1. Use Extended Events to monitor dimension query processing
  2. Try to use faster storage (SSD) or more disk drives for quicker responses to Storage Engine requests
  3. 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

 

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