runnable
The session's task is in the runnable queue of a scheduler while waiting to get a time quantum.
Detailed Description​
The session's task is in the runnable queue of a scheduler while waiting to get a time quantum. The thread has all the resources it needs to run, i.e. it is not waiting on any other resource and is placed on CPU and run when it comes to the top of the queue.
How to reduce this wait​
There will always be an amount of runnable wait, as threads are only allowed 4ms on CPU before they are swapped out. If you have a significant amount of runnable wait time, make sure that the server CPU is not overloaded.
Ensure the maximum degree of parallelism (MAXDOP) is not flooding the system with a large number of parallel executions on large tables.
Additional Links​
- MS Docs - sys.dm_exec_requests
- MS Docs - Find the query text for a running batch
- Greg Dodd blog - Runnable, Running and Suspended
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.