Latch wait time  
Author Message
PeteT





PostPosted: Mon Nov 15 23:08:37 CST 2004 Top

SQL Server >> Latch wait time

Does anyone know the potential causes of a high average latch wait time
(12-20 sec) for LATCH_EX? Total average disk queue depth << 1, CPU at 40%,
not many inserts, client side cursors.

SQL Server249  
 
 
AnthonyThomas





PostPosted: Mon Nov 15 23:08:37 CST 2004 Top

SQL Server >> Latch wait time If the client side cursors are not detached from the main data source, that
could do it. Also, just the network traffic load to get it into a
scrollable client side cursor could cause excess latches.

What does you estimated execution plan look like?

Sincerely,


Anthony Thomas


--



> Does anyone know the potential causes of a high average latch wait time
> (12-20 sec) for LATCH_EX? Total average disk queue depth << 1, CPU at
40%,
> not many inserts, client side cursors.
>
>


 
 
Sue





PostPosted: Tue Nov 16 08:50:44 CST 2004 Top

SQL Server >> Latch wait time You may want to monitor memory (vs disks) for this. You can
find explanations in the Latch_x section of the following
article:
http://www.sqldev.net/articles/WaitTypes.htm

-Sue

On Mon, 15 Nov 2004 22:22:52 -0500, "Bob S"


>Does anyone know the potential causes of a high average latch wait time
>(12-20 sec) for LATCH_EX? Total average disk queue depth << 1, CPU at 40%,
>not many inserts, client side cursors.
>