List All Parallel Queries – SQL in Sixty Seconds #098


 

During the recent Comprehensive Database Performance Health Check, my client asked me if I have a query which can list all the parallel queries which are running in the server along with the count of times the query has executed.

Yes, it is indeed possible to go back to SQL Server cache and find all the queries which are running in parallel. Additionally, the cache will also show how many times the query has run since the data is in the cache. Watch this video about how you can do it.

The script used in the video you can download from this