• Given that CXPACKET waits was larger than the other waits, thought I'd go looking for good info, and found some from a really good source:

    http://www.brentozar.com/archive/2013/08/what-is-the-cxpacket-wait-type-and-how-do-you-reduce-it/[/url]

    Read it, and toward the end, there's a link there for more on how to tune. Enjoy!

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)