SATA or SCSi?  | | 
November 17th, 2004, 11:26 AM
|
#1 (permalink)
| | Ultimate Member
Join Date: Oct 2001 Location: Reno, NV
Posts: 1,624
|
I am going to be putting together a Database server for my work. There is going to be a server using an Opteron based setup connected to an external storage box. I have the option of having either SATA or SCSi in the external storage that will hold up to 12 drives.
The server is going to be used to house a database for our general ledger, accounts payable, and a few other things. There may be 15 or so users connected at the same time with a couple connecting remotley using Terminal Services. Terminal Services will be running on another server. And the database may only be about 10-15GB.
Do i need SCSi 320 drives in this setup or can i go with SATA? Can i use SATA 7200 rpm drives or go with the 10,000 rpms? I am trying to cut back on costs here, and i can get two 250GB SATA drives for the price on one 72GB SCSi drive.
Thank you for any help. 
__________________
"Life moves pretty fast, if you dont stop to look around once in a while, you could miss it." -FB
| 
|  | |
November 17th, 2004, 11:33 AM
|
#2 (permalink)
| | Ultimate Member
Join Date: Nov 2002 Location: Boise, Idaho
Posts: 2,782
|
SCSI if they money is available
SATA otherwise
__________________
JOIN [FaD] | TEAM NUMBER 2037 | http://www.techimo.com/forum/t121132.html
| |
| | |
November 17th, 2004, 11:49 AM
|
#3 (permalink)
| | Member
Join Date: Jul 2003 Location: Savannah
Posts: 152
|
I'd go with SCSI to handle the bandwidth you'll need... you have a max 15 users and 10-15 GB of data? If the database is that small you shouldn't need all the extra space. | |
| | |
November 17th, 2004, 02:29 PM
|
#4 (permalink)
| | Ultimate Member
Join Date: Nov 2002
Posts: 1,338
|
Service time (i.e., seek) not throughput is the major issue in a multiuser environment. If you put ATA drives with a slower service time in there, the users will know it -- especially at a peek load.
SCSI drives are also considerably more reliable than ATA drives. | |
| | |
November 17th, 2004, 02:49 PM
|
#5 (permalink)
| | Ultimate Member
Join Date: Oct 2001 Location: Reno, NV
Posts: 1,624
|
Thank you for the replies.
The main thing i was worried about was the seek time on the ATA versus the SCSi. So i may just go with the SCSi.
thank you again for the replies | |
| | |
November 18th, 2004, 03:39 AM
|
#6 (permalink)
| | Ultimate Member
Join Date: Oct 2001 Location: Augsburg, Germany
Posts: 5,586
|
The pros of SCSI: Seek times, sustained throughput even when the drive fills up, and general reliability.
The pros of IDE: Cheap in initial purchase. | |
| | |
November 18th, 2004, 04:54 AM
|
#7 (permalink)
| | Ultimate Member
Join Date: Apr 2003 Location: PA. USA
Posts: 3,310
|
Thats pretty samll. 15 users, I dont think they are going to drag sata down too much. Sure seek times-LOL remeber ping on the net will factor into and with 15 users I dont think the lag will be from seeks.... Depends on the traffic as wether scsi price is worth it really. 15gig db isnt that small BUT the user amount is low. You could use more then one db and thus have it spanned on multiple sata drives. I personally have 5 db's. Get some raptors if you relaly want some speed on sata and dont need tons of data storage.
__________________
R.I.P. TKOP
You will always be in our hearts and thoughts. God bless.
| |
| | | Thread Tools | Search this Thread | | | | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Most Active Discussions  | | | | |   Recent Discussions  | | | | |
 |
hardware
prices 
