• The top wait on live always seems to be this:

    wait_typewait_time_ms

    MSQL_XP26126343

    I believe this is due to SQL waiting on extended stored procs to complete yet I can't find a process relating to this. I use RedGate for SQL backup and the general feedback online is that an update from v5 is required.