BI performance counter: Total measure group queries

Applies to

SSAS

Description

In a cube, measures are grouped by their underlying fact tables into measure groups. This performance counter relates to the measurement of Analysis Services storage engine queries. It monitors the total number of measure group queries that were processed since the restart of the Analysis Services instance.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

  1. Set the ‘IgnoreUnrelatedDimensions’ measure group property to ‘False’ so you can hide measure values when seen against an unrelated dimension attribute
  2. Create multiple partitions for a measure group with very large fact tables
  3. Optimize the data types of fields used by Analysis Services at the source database

Additional research

Measures and Measure Groups
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