#StackBounty: #sql-server #performance #performance-tuning #multi-thread Identify threads with maximum difference in time

Bounty: 50

I have many parallel executing queries in my SQL Server database. I need to find out queries where the difference in time for the longest thread and the shortest thread is high (excluding co-ordinator thread). In fact, I need to find top 10 such queries with highest difference (from the queries that are getting exeuted in the span of 1 hour). How to track this information in SQL Server?

Note: I am using SQL Server 2012.

enter image description here


Get this bounty!!!