Latch wait time

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

From: Bob S (noone_at_nowhere.com)
Date: 11/16/04


Date: Mon, 15 Nov 2004 22:22:52 -0500

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.