Hi Grant,

Thanks for this. Think blocking is the most probable, and have set up an XE to catch something next time..

We are using Redgate and a quick question about the counters:

a) The avg. lock time briefly shoots up when the query starts, but then flatlines for the duration of  execution. Can this be expected behaviour when there is massive blocking?
b) Will logical reads also shoots up dramatically when blocking occurs?

Thanks,