WAITING
Short Description
The thread is waiting for a resource or event before it can proceed.
Detailed Description​
- The thread is blocked waiting for something (I/O, lock, thread, resource).
How to reduce this wait​
- Check if many threads are WAITING for locks or disk.
- Check M_BLOCKED_TRANSACTIONS and M_WAIT_STATISTICS
- Look for lock contention or disk I/O bottlenecks.
- Optimize SQL, indexes, or workload to reduce contention.
Additional Links​
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.