Lock Escalations and Execution Plan shapes
Lock Escalations are really, really bad, because you end up with an Exclusive or Shared Lock at the table level. And placing such restrictive locks at the table level reduces your concurrency and the throughput of your database. I don’t want to talk today about the basics of Lock Escalations. Today I want to concentrate …
