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 Add more physical memory to the computer Use HardMemoryLimit setting to adjust out-of-memory condition 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
