Locking and Blocking – When Read Queries Block Write Queries Demo
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. Blog readers get 25% off the Everything Bundle — over 100 hours of performance tuning content. Need hands-on help? I offer consulting engagements from targeted investigations to ongoing retainers. Want a quick sanity check before committing to a full engagement? Schedule a call — no commitment required.
Great stuff Erik, love your work.
Just wanted to know if this behaviour is when RCSI enabled as well?
Thanks!
Hey Joe – no, both Read Committed Snapshot Isolation and Snapshot Isolation spare you this particular misery.