Re: Disappointing performance in db migrated from MS SQL Server

>>>>> "LO" == Leon Out <leon-lists(at)comvision(dot)com> writes:

LO> Josh, the disks in the new system should be substantially faster than
LO> the old. Both are Ultra160 SCSI RAID 5 arrays, but the new system has
LO> 15k RPM disks, as opposed to the 10k RPM disks in the old system.

If you've got the time, try making your 5 disk array into a RAID10
plus one spare. I found that with that few disks, RAID10 was a better
performer for an even mix of read/write to the DB.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com Rockville, MD +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/