• That's related to parallel table/index scans. Probably means you have a lot of inefficient queries which are doing large scans. Worth looking into

    btw, aggregated wait stats over 5 days is hard to work with, because you don't know when the waits were incurred, whether it was over-night jobs, maintenance or business-time queries. I'd suggest looking at wait stats per hour at the most and looking at the trends over a few days.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass