BI performance counter: Total queries from cache direct

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

  1. Optimize the data types of fields used by Analysis Services at the source database
  2. Reduce Data type conversions
  3. 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

 

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