Tom Zika is angling to become the Service Broker Baron:
I was paged about a blocking chain where the blocked resource was a Service Broker queue, the lead blocked transaction was called
CSbRollbackHandlerTask::DisableQ
, the lock mode wasSCH-M
and even lock partitioning was involved. I won’t repro fully this time, but I’ve covered lock partitioning repro in my post Async-stats-update-causing-blocking. The goal was to capture an instance of transactionCSbRollbackHandlerTask::DisableQ
with the same lock mode.
Click through for a demo and how to troubleshoot the issue.