running
The process is on the CPU, currently working
Detailed Description​
This is not a wait event but rather a status for the active SQL statement.
Running means that the process is running on the CPU, currently working (Compared to Runnable which means it's waiting to be scheduled on to the CPU).
How to reduce this wait​
Identify the top statements which spend the most time in the running state and look to optimise them. Tuning SQL statements to make them more efficient by reducing sorting or joining and doing fewer logical I/Os will reduce the CPU time required. This could be through adding an index or rewriting the query.
Moving to a database server with faster CPUs will also reduce the CPU time used and therefore the time spent in running state. Adding hardware should only be considered once other database tuning techniques have been exhausted.
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.