Internals

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.

Have you ever wondered what the purpose of the KEEP PLAN hint is? The documentation doesn’t help this time. Look no further than here to find out.