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.
DBAs, Server administrators, BI developers
- 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
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