• The disk subsystem is presented storage from a Dell EQ array. Both, the previous and current setups were on this, and seek times are under 10ms, so we have more or less ruled out Disk as root cause.

    For MAXDOP, all our queries use default and system also does too.

    WAIT stats do not look terribly bad, but I don't have a good way of seeing them over time currently? can someone suggest one?

    We see sporatic times where CXPACKET times show up, but usually only for a second or two. Other times we see random PAGEIOLATCH_SH waits as well, but not enough to really see a root cause. The vast majority of queries don't show wait times and are runnable or running.

    Thanks again for any pointers.