What to know what is Latching in sqlserver and how it works

• Hassans

  SSC Enthusiast

  Points: 136

  More actions

  January 23, 2009 at 6:39 am

  #127582

  Hi,

  Can some body help me in understanding latching in sqlserver. I want to know in which way it works and purpose of it.

  Regards

  Hassan

• NitinPatel31

  Hall of Fame

  Points: 3721

  More actions

  January 23, 2009 at 6:50 am

  #931761

  Latches are very lightweight, short-term synchronization objects protecting actions that need not be locked for the life of a transaction. They are primarily used to protect a row when read for a connection.

  See this for more

  http://msdn.microsoft.com/en-us/library/aa224727.aspx

  Regards,
  Nitin