When the DB engine would try to lock page first and then it escalates locks to page and then table. If we
understand that whole table would be locked for the processing thenn
this is better to use TABLOCK hint and get complete table blocked. This
is a nice way to avoid the wastage of sql server DB engine processing
for lock escalation. Somewhere you may also need to use TABLOCKX when
you want an exclusive lock on the table in the query.
No comments:
Post a Comment