We are currently generating a high volumes of writes against our Dell 2950 database server from our ads application.
The Ads application runs a Maintenance process every hour and is at this time that we see a queuing of raw insert. Few of the insert finish after 40-60 seconds then the rest finish at once when the Maintenance finish. Sometime we see 200-500 processes after the Maintenance finish.
On normal operation we don’t see those inserts since they are processed very fast but we need to expedite these inserts.
Our servers use a SaaS battery backup controller with 256 MB cache and 15K RPM SCSI hard drive.