BI performance counter: Total queries from file

Applies to

SSAS

Description

Analysis Services is a file-based database engine. It reads data from different files, makes the joins, and services the requests. This performance counter measures the total number of queries that were answered from files since the restart of the Analysis Services instance.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

  1. Consider changing the value of “LimitSystemFileCacheSizeMB” property according to your RAM requirements
  2. Avoid doing unnecessary aggregations
  3. Reduce the number of attributes in the dimensions
  4. Optimize the data types of fields used by Analysis Services at the source database

Additional research

Performance Counters (SSAS)
Avoid Common SQL Server Analysis Services Problems
Performance Counters for SSAS 2008

 

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