Latching Wait Time

• a7856320

  Valued Member

  Points: 50

  More actions

  December 2, 2002 at 12:26 pm

  #159010

  Performance indicates the average latch wait time and latch wait/sec are quite high. Can someone advise what these counters exactly mean and how to reconfigure the system in order to reduce the wait time.

  Running ERP application on 8 processors machine with 16GB memory and SAN storage.

  SQL Server 2000 EE with SP2.

• grobido

  Old Hand

  Points: 320

  More actions

  December 2, 2002 at 3:39 pm

  #442838

  Here are a couple of pages that explain latching. This info is on books online.

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_4kok.asp

  and

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_0odj.asp

  What do your memory and disk counters look like. Are there any bottlenecks there? This is probably related to one of these other issues.

  Greg Robidoux

  Edgewood Solutions

  http://www.edgewoodsolutions.com

  
  Greg Robidoux
  Edgewood Solutions
  www.edgewoodsolutions.com