BI performance counter: Current latch waits

Applies to

SSAS

Description

This performance counter measures current number of threads waiting for a latch due to internal server locks.

These are latch requests that could not be given immediate grants and are in a wait state. The value of this counter is reset whenever the service is restarted.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

  1. Minimize the MDX query duration
  2. Add more physical memory to the computer
  3. Avoid processing at peak hours to avoid query and processing collisions
  4. Combine processing into a single transaction/batch XMLA tag

Additional research

Why doesn’t SSAS cache the entire cube?
Analysis Services Stops Accepting New Connections -Processing commit locks hurt
Performance Counters (SSAS)
Analysis Services 2005 – Performance Counter Guidance

 

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