Browse by Tags

• Overhead of Row Versioning

  Last week I was teaching a class on snapshot isolation and we discussed the overheads of snapshot isolation. There are three main overheads that you need to be aware of when you enable snapshot isolation read-committed-snapshot on a database. First, each Read More... Posted Sunday, March 30, 2008 12:41 AM by Sunil Agarwal | 7 Comments Filed under: Concurrency

• Read-Only filegroups and Locking

  I recently saw a newsgroup post that sort of implied that accessing data residing on read-only filegroups can save you on locking. Well, it could, but it does not. If you really want to save on locks, the whole database needs to be set to read-only. Back Read More... Posted Monday, January 08, 2007 5:28 AM by Sunil Agarwal | 1 Comments Filed under: Concurrency

• Troubleshooting deadlocks in SQL2005

  This post describes the enhanced diagnostics for deadlocks in SQL2005 and how to minimize them Read More... Posted Monday, June 05, 2006 4:18 PM by Sunil Agarwal | 9 Comments Filed under: Concurrency

• Range locks

  Lately I have seen some quesitons on range locks. Why certain keys are locked? How is this behavior different for unique vs. non-unique indexes? So I played around with range locks and here are my findings so far. Range locks are obtained on index keys Read More... Posted Friday, May 26, 2006 4:44 PM by Sunil Agarwal | 2 Comments Filed under: Concurrency

• Lock Escalation in SQL2005

  lock escalation Read More... Posted Wednesday, May 17, 2006 7:06 PM by Sunil Agarwal | 9 Comments Filed under: Concurrency