BI performance counter: Total lookups

Applies to

SSAS

Description

This performance counter measures the total number of aggregation lookups into the memory cache.

A high value for this performance counter indicates that most of your queries are using a shared reference set which could be an indication that most of your queries are optimal. The value of this counter is reset whenever Analysis Services service is restarted.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

  1. Ensure that you have enough memory to fit your cache
  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 Monitoring for SSAS – Perfmon Counter Cheat Sheet
Performance Counters (SSAS)

 

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