• you are correct I was really trying to solve the mystery of resource-list why it showed nothing. Fixing the underlying issue is something all together different. It just so happens the SQL is coming from Microstragey its more or less dynamic.

    Microsoft says 2016 Sp2 is suppose to help...I shall cross my fingers.

    https://support.microsoft.com/en-us/help/4089473/better-intra-query-parallelism-deadlock-troubleshooting-in-sql-server2