Blocking

This post is dedicated to all 10 other DBAs that use Service Broker (you know who you are).

I recently encountered an issue where an index rebuild set to wait_at_low_priority ended up blocking an asynchronous statistics update. This interaction led to a large blocking chain where queries were waiting on the async stats update and started to timeout.