We have a Win 2003 Server 64 bit Server 4GB ram - Raided disk. Runs a single app. App is using approx 15mb ram, total memory sits at flat-lined 550MB
We are experiencing periods of freezing where the server just pauses - 200 connected work station. Everything waits and then away it goes again. Can last upto 60 seconds , has been doing it for months - every 3 - 4 weeks, just once or twice.
More recently its every few days and every few hours, sometimes minutes
Have been trying to track it down using Performance Monitor: Here are some numbers,
Avg Disk Queue Length = between .80 and 1.8 - (Scale is 10)
Current Disk Queue Length = 1 (Scale is 10)
Average Disk sec / Read is .003 (Scale is 1000)
Average Disk Write Queue Length = .770 (Scale is 100)
Pages/sec = 320 (Scale is 1)
Page Faults/Sec = 4000 (Scale is .001)
I don't understand how to apply the scales and the numbers in Last, Average, Minimum don't vary when I change the scale.
The database is a Revelation LinearHash Service - we have used it for 15 years, starting on Novell. No major changes to the apps.