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
- Minimize the MDX query duration
- Add more physical memory to the computer
- Avoid processing at peak hours to avoid query and processing collisions
- 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
See more
Check out SpotLight, a free, cloud based SQL Server monitoring tool to easily detect, monitor, and solve SQL Server performance problems on any device