• Check for WAITS, CX_PACKET WAITS and any IO issues. Also can you let us know the metrics for the CPU, Memory and the Disk counters.

    Do you also experience any blockings and index fragmentation ? Did all your DB Maintenance jobs ran successfully.

    --

    SQLBuddy