BI performance counter: Dimension Property Files

Applies to

SSAS

Description

The characteristics or properties of an Analysis Services dimension are defined by the metadata for that dimension, based on the settings of various dimension properties, and on the attributes or hierarchies that are contained by the dimension.

This performance counter relates to the measurement of Analysis Services internal server memory and it monitors the total number of dimension property files.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

  1. Add more physical memory to the computer
  2. Use HardMemoryLimit setting to adjust out-of-memory condition
  3. Monitor your memory usage using DMVs

Additional research

SSAS Performance Monitor Counters
Performance Counters (SSAS)
Memory Properties
Understanding SQL Server Memory Grant and Memory Management/

 

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