September 21, 2010 at 8:07 am
One of our critical servers started to perform very slow since yesterday. Here is the detail:
SQL Server and Windows detail:
Microsoft SQL Server 2000 - 8.00.2282 (Intel X86) Dec 30 2008 02:22:41 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
I see few(around 40) PAGEIOLATCH_SH waittypes most of them sleeping. Memory utilization and cpu utilization is normal(under 50%).
avg disk Q length looks a bit on higher side (>30)
What else should i look at?
September 24, 2010 at 5:19 am
Just to update that we found the issue. Batteries of one of the controllers had failed. the read/write cache was disabled and hence the slowness and low disk throughput. it has been replaced and system looks better now.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply