Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Posts
    12

    Unanswered: Page level locking vs. Row level locking

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

    Thanks in advance!!!

  2. #2
    Join Date
    Sep 2002
    Location
    Germany, near Aachen
    Posts
    120

    Re: Page level locking vs. Row level locking


    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.

  3. #3
    Join Date
    Sep 2002
    Location
    Hong Kong
    Posts
    159

    Re: Page level locking vs. Row level locking

    Originally posted by Bernd Dulfer

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


    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •