[feature request] RunningQueries - DOP

[FuriousDBA]

Hi,
can we add [dop] column from sys.dm_exec_requests to the RunningQueries tab?
Thx

[DavidWiseman]

Thanks for the suggestion - I might consider it for a future release.

[DavidWiseman]

Notes for me:

sp_BlitzWho returns degree_of_parallelism when @ExpertMode=1. This is returned from sys.dm_exec_query_memory_grants rather than sys.dm_exec_requests. sp_WhoIsActive also returns dop from sys.dm_exec_query_memory_grants when @get_additional_info=1 (as part of an XML column with a load of other info).

dop is described as "Degree of parallelism of this query." for both sys.dm_exec_query_memory_grants and sys.dm_exec_requests. The column was only added to sys.dm_exec_requests from SQL 2016 onwards. sys.dm_exec_query_memory_grants is available from SQL 2008 onwards.

It's probably fine just to use dop from sys.dm_exec_requests. It returns a dop for every row in sys.dm_exec_requests which could be an advantage. It also avoids an extra join so the additional overhead should be minimal. We would need to skip collecting this column for 2005-2014 instead of just 2005 - not a big deal as all of them are out of even extended support.

[DavidWiseman]

Included in 3.31 🚀