BI performance counter: Total misses

Applies to

SSAS

Description

This performance counter measures the number of times that queries unsuccessfully attempted to retrieve data from the memory cache. Expect the value of this counter to increase shortly after cube processing or Analysis Services service restart. If this number continues to grow than it may indicate insufficient memory or that queries being run are not optimal.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

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

Additional research

SSAS Performance Monitor Counters
Performance Counters (SSAS)
Monitoring queries with Performance Monitor counters

 

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