SuperLatches

• shwet

  SSC Rookie

  Points: 25

  More actions

  July 23, 2007 at 4:47 am

  #119790

  What are SuperLatches in SQL Server?

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  July 23, 2007 at 5:08 am

  #721487

  SQL Server uses “superlatches” in 32-processor configurations. These superlatches reduce the use of Page latches, which in turn reduces resource contention.

  This was from a website.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com