Re: Latch wait time
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 11/16/04
- Next message: Sue Hoegemeier: "Re: looking for a tool to generate a database script..."
- Previous message: Mike Epprecht \(SQL MVP\): "Re: Error 2809"
- In reply to: Bob S: "Latch wait time"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 16 Nov 2004 07:50:44 -0700
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"
<noone@nowhere.com> wrote:
>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.
>
- Next message: Sue Hoegemeier: "Re: looking for a tool to generate a database script..."
- Previous message: Mike Epprecht \(SQL MVP\): "Re: Error 2809"
- In reply to: Bob S: "Latch wait time"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
