BI performance counter: Total inserts

Applies to

SSAS

Description

This performance counter relates to statistics related to the Analysis Services aggregation cache and it measures the total number of insertions into the cache per partition per cube per Analysis Services database. The value of this counter is usually high and is reset whenever the Analysis Services is restarted.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

  1. Try and put SSAS databases on very fast (ideally solid-state disks) storage devices
  2. Partition large cubes which reduces logical IO requests
  3. Add more physical memory to the computer

Additional research

Performance Counters (SSAS)
Determining SSAS Aggregation Usage
Storage Engine Cache Aggregation and its Implications for Dimension Design

 

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