• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 347
  • Last Modified:

locking and latching

I need to explain to lay people the difference between locks and latch waits.

ie latch being a mini lock .
can anyone suggest some good reference material I can refer people to?
Amanda Walshaw
Amanda Walshaw
2 Solutions
Raja Jegan RSQL Server DBA & ArchitectCommented:
"Locks and latches are similar objects but they have a slightly different purpose. Locks ensure that the same data element cannot be modified by two different connections at the same time; latches, on the other hand, simply ensure that the data page on which the data element resides is physically readable and writable. A latch is only maintained on the data page while the data is being changed, as opposed to locks which are maintained for the duration of the entire transaction."

Check out this article:

Also check this:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now