Tuesday, March 20, 2012

Row Level Locking

I have a busy transactional table , I wanna use row level locking mechanism in msSQL.

SELECT * FROM PARTYWITH (UPDLOCK ROWLOCK)

where LastName ='Clinton'

is there anydownsides of this approach?

Here's a pretty good article talking about the pro's and con's

http://www.sql-server-performance.com/lock_contention_tamed_article.asp

From what I can tell, the only disadvantage, isnt specific to ROWLOCK itself, just locking in general in busy tables.

No comments:

Post a Comment