What is the difference between page level locking and row level locking.?

Thanks in advance!!!

What is the difference between page level locking and row level locking.?


With page level locking the whole page, and therefore all rows on that page, is locked when a data row on the page is accessed.
With row level locking only one row on the page is locked, the other rows are accessible.

Hi,

Just to add there is also more of an overhead with row level locking. The server *may* require the "Number of Locks" configuration parameter to be increased.

With Data Only and Row Level locking index pages are no longer locked when being updated.