Groups | Blog | Home
all groups > sql server (microsoft) > january 2004 >

sql server (microsoft) : Latch wait time


Paul
1/19/2004 12:04:59 AM
Hi,
I've got an SQL 2000 server with a few databases on it. I's been working for
2 years just fine.
But approx 3 months ago it started showing short periods of extreme disk
activity. No major changes in databases were made. The server is unavailable
when this is happening. I've set up a bunch of counters and all I found is
Disk Queue is up to 2800 and the Average Latch Wait time is 590 ms. Is it
normal? Another server has 1.5 ms. What I should check else?
Thanks

Martin
1/19/2004 9:11:31 AM
What's the status of your logfiles?

"Paul" <paul_unix@shaw.ca> schreef in bericht
news:LaFOb.167135$ts4.66976@pd7tw3no...
[quoted text, click to view]

Paul
1/20/2004 2:24:18 AM
As usual, nothoing remarkable, no errors, etc.
Performance logs shows crazy disk activity though..
[quoted text, click to view]

mountain man
1/20/2004 7:04:34 AM
Do you run maintenance tasks (reorganisation
and reindexation, etc) on the databases, or not?

Are you running query optimisations, etc?

Sometimes the running of sp_updatestatistics
assists in certain instances.

Did traffic increase 3 months ago, or has the
database transaction load been reasonably constant?


[quoted text, click to view]

AddThis Social Bookmark Button