Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MichaelP
Jedi Yak
2489 Posts |
 Posted - 2004-09-02 : 15:25:12
|
| Anyone running SQL server on some SATA arrays? I'm looking for Pros / Cons for running SQL on SATA and or case studies etc.Thanks!Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-09-02 : 15:32:38
|
| Generally speaking, Tom's Hardware has some decent articles on SATA.http://www17.tomshardware.com/search/search.html?category=all&words=sata |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-03 : 01:57:36
|
| I wouldn't run it on a high I/O or mission critical system. The drives have fairly high failure rates. For things like archive/web hosting databases, etc though I think it's fine.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-09-03 : 03:41:22
|
| I wouldn't have any problem using SATA drives in an array. Derrick, where have you seen high failure rates for these drives? Are you talking about WD raptors? (1.2 million hours MTBF). Compare that to Seagata Cheetah 10k/15k at 1.4 million hours MTBF. The raptors are also 1/3 the price of the equivalent Cheetah drives. btw, don't use consumer oriented drives in your RAID if you can help it, these drives are slower (7200 RPM) and have MTBFs that are sometimes lower, but usually not by much.Of course you will be limited to using 36GB or 74GB capacities if you choose the SATA (raptor is the only way to go w/SATA btw) option.-ec |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-09-03 : 03:51:03
|
| We used a couple of these alongside a SCSI system to keep system databases on and they were just fine. Much better than standard IDE, which tends to crumple and fail under the stress.It's important to get a good quality card though, or if the SATA controller is on the motherboard make sure it's not one of those that uses the PCI bus, or somesuch.-------Moo. :) |
|
|
|
|
|
|
SQL Server on SATA Array