Performance Degraded and RESOURCE_SEMAPHORE started appearing

Hello,
We are running a 4 CPU SQL Server 2000 with RAID arrays of 5 disks each on
two separate channels of a controller.
It all worked great... However, a few days ago the performance went way
down.
I am noticing a lot of RESOURCE_SEMAPHORE waittypes in the sysprocesses
table.
Also the Avg Disk Queue Length counter started showing high numbers.
Is there something specific I need to look for? When running the SQL
Profiler I do not see anything unusual - just that the queries are taking
much longer to complete.
Should I reboot the server? It was not rebooted since March, 2003.
Please let me know!
Thank you,
ArsenHi Andrew,
All disks look okay. I do not see scans of tables. Indexes are used as
before.
Although, I just noticed that the Cache Hit is around 52%, where as on my
other SQL Server boxes it is around 98%. Could this be something?
How to fix this? Reboot?
Arsen|||while this sounds like a hardware problem occured at the
point a few days ago, can you just quickly check to see if
there is a particular query causing this
look in profiler for anything >> 5sec cpu or duration
>--Original Message--
>Hello,
>We are running a 4 CPU SQL Server 2000 with RAID arrays
of 5 disks each on
>two separate channels of a controller.
>It all worked great... However, a few days ago the
performance went way
>down.
>I am noticing a lot of RESOURCE_SEMAPHORE waittypes in
the sysprocesses
>table.
>Also the Avg Disk Queue Length counter started showing
high numbers.
>Is there something specific I need to look for? When
running the SQL
>Profiler I do not see anything unusual - just that the
queries are taking
>much longer to complete.
>Should I reboot the server? It was not rebooted since
March, 2003.
>Please let me know!
>Thank you,
>Arsen
>
>.
>