pagelatch question

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: james (kush_at_brandes.com)
Date: 02/26/04 

Date: Wed, 25 Feb 2004 17:11:36 -0800

We are running sql server 2000 on Data center. There has been performance
issues and I have noticed from sysprocesses table there is always wait on
Pagelatch_ex, Pagelatch_sh, Pageiolatch. When I look at Perfmon counter I
see Avg latch wait time 420 seconds, Latch wait/sec 200 and Pagesplit/sec 5.

I feel like most of the time has been spent on latch wait of some sort,
following are my questin
1. Is Avg latch wait time 420 is normal?
2. Why so many (200/sec) latch wait? Is it because of high page split
(5/sec, or is it really high).
3. What Can we do about those latches?

I would really appreciate if someone can give more information about the
latches and may be send a link to good web site/article about it.

thanks,

Relevant Pages

  • Re: Inferred latches questions
    ... Latches are transparent. ... The data input of a latch must not change short before the latch is disabled. ... -- variable to hold the sum a + b when determinig overflow variable tmp: ... In an ALU it may be a good idea, to store flags, like the overflow flag. ...
    (comp.lang.vhdl)
  • Re: Nibz processor @ 472 LEs (16 bit generic specified)
    ... The device actually has a hardware latch as a resource (unlikely ... The synthesized code ends up mapping the source code to the above ... being when the device didn't have hard latches so they got cobbled ... register bit, now at 33+ MHz. ...
    (comp.lang.vhdl)
  • Latches: What Are They For?
    ... I'm just starting to get into embedded systems and I recently stumbled across latches. ... It is my understanding that I'd usually set the bits (in my case, seven bits for a 7-segment LED display) on my microcontroller first, and then set the input enable bit high on the latch. ... At some point, I'd imagine that I'd have to set both the "input enable" and "output enable" pins back to low; but, I'm not sure exactly when to do this. ...
    (comp.arch.embedded)
  • Re: Cant latch top.
    ... I couldn't get the latches to latch. ... Wind the windows down or open the doors first ... but the windows were open. ...
    (rec.autos.makers.mazda.miata)
  • Re: Cant latch top.
    ... I couldn't get the latches to latch. ... I tried adjusting them (turning the adjusting ... nut to extend the latches as far as possible, ...
    (rec.autos.makers.mazda.miata)