Datastore on SQL "eats" the disk

[Ompa]

We have a 70+ serverfarm with the datastore on a dedicated SQL 2000 server. Suddenly the comp starts writing to disk at a speed that it can't handle, and it becomes totally unresponsive. We are talking "Current diskqueue lengt" over 150, and a "%Disk write time" up to 18000(?!). This causes "DBConnect failure" on our Data collectors, and login fails. We have reinstalled the server and changed all hardware without any luck...

-Ompa

 

[KCDave03]

it sounds like it could be a memory bottleneck, could it be that all that disk activity is page swapping?

 

[Ompa]

No, the funny bit is that about 80 to 90% of other system resources is idle, and pages per second is totally normal. It uses about 30% of physical memory.

-Ompa