Async stats update causing blocking

9 minutes

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.

KEEP PLAN Demystified

16 minutes
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.