Forum Home
Press F1
 
Thread ID: 97434 2009-02-15 19:52:00 SATA vs SCSI in a server nofam (9009) Press F1
Post ID Timestamp Content User
748234 2009-02-15 19:52:00 I'm in the process of spec'ing a new server for our in-house POS system, which is a large multi-table, multi-user database, running on Redhat Linux. Traditionally we've always used IBM pSeries gear, running AIX, but Redhat Enterprise is now the preferred option.

The spec that's been suggested has SATA drives, which concerns me for a 24/7 server. I'd like some advice on:

1. The reliability of SATA vs SCSI, not so much in terms of MTTF, but more which is more susceptible to bad sectors etc.

2. The performance of SATA vs SCSI in terms of command queuing on a busy database with heavy I/O

TIA!! :thumbs:
nofam (9009)
748235 2009-02-15 20:03:00 Here:

www.umich.edu
pctek (84)
748236 2009-02-15 22:02:00 1. The reliability of SATA vs SCSI, not so much in terms of MTTF, but more which is more susceptible to bad sectors etc.

2. The performance of SATA vs SCSI in terms of command queuing on a busy database with heavy I/O

TIA!! :thumbs:

1. the internals of the drive are almost the same, so MTTF will be much the same, on SCSI disks you they have been "run in" a bit more. as for bad sectors and such you will find it all to be much the same.

2. there are many kinds of SCSI, so the answer is maybe....
cache, spin speed, command queing and all such come in to the mix


if it was my box I would use mirrored SATA2 drives with big cache.

dont get too large a disk if you want good MTTF, the bigest disk on the market are always the ifrst to fail, they push the tech as far as they can.

in out server enviroment we never use more than 250GB in a single disk.
robsonde (120)
748237 2009-02-16 08:29:00 As stated above the physical parts of the drive may be exactly the same.

As I understand it all PATA and SATA drive speeds are quoted in burst mode - not sustainable transfer rates. SCSI is sustainable. There is no doubt in my mind that a modern SCSI system is faster than SATA ... but is the speed and cost needed?
johnd (85)
748238 2009-02-17 04:58:00 SATA drives wont have the bandwidth of the SCSI disks, especially if you are talking heavy use DB I/O...In fact now SAS (Serial SCSI) are the preferred disks. SolMiester (139)
1