BI performance counter: Total direct hits

Applies to

SSAS

Description

This performance counter measures the total number of sub-cube queries that have been answered from data in memory cache since the Analysis Services service was started.

The value of this counter is generally high. It should be compared to Total Misses performance counter to evaluate the percentage of sub-cube queries that are resolved using cache.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

  1. Add more physical memory to the computer
  2. Partition large cubes which reduces logical IO requests
  3. 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