Re: If you know SCSI
If your CPU is pegged, then you're most likely not IO bound. You might check your data transfer rates to make sure you've got things like UDMA enabled (sometimes this gets shut off for one reason or another).
It really sounds like your box is just having trouble crunching the numbers on PT which isn't going to get fixed by a SCSI system, unless you also throw quad Xeons behind it.
Methinks those "database updates" are PT doing all kinds of B-Tree inserts, indexing, etc. Get an Athlon 64 and some SATA drives and be happy w/ the performance you get there
Just my .02
|