Alan Wen wrote:
> IDE is single stream connection
> SCSI is multiple stream
> what is SATA?
>
> In terms of performance, if I replace my servers with SATA based
> servers - will I take a performance hit - even a little?
>
> Thanks.

It depends on many things. Current SCSI drives on a current top line SCSI
controller will outperform the best SATA drives and controller for most SQL
servers, heavily loaded file servers, etc. Anywhere you have a lot of
clients accessing random data simutaneously. In a lightly loaded server or
normal domain controller with top line SATA drives and a top line controller
(not the onboard software controllers on current motherboards) I don't think
you'd see any difference that was noticable. Check put these SATA
controllers

http://www.3ware.com/

They are really nice, very fast. Their sales rep told me he wouldn't
recommend them over SCSI for a busy SQL server. He said they will be there
in a year but not now. His honesty was refreshing. I will be trying their
stuff.

Kerry