Improving Disk Performance
Posted on 2005-03-16
I have an MS SQL DB which is relatively small - 15GB currently on an XP Prof Machine - Single HD.
This DB is not accessed by anyone and is writes approx 1million records per day (very few reads max 2000). We would like to improve the IO Writes as it is a bottle neck at the moment.
We are considering implementing RAID on it. Cheap and cheerful... PCI RAID 0 with two SATA drives. We previously performed a similar upgrade (RAID 0+1) with very good success on another machine, but we used expensive Maxtor Raptor Drives.
This is not a critical process at all (hence RAID 0 - with backup to IDE). So we are looking for a cheap SATA Drive to put on. Our thinking is:
- RAID PCI Controller
- SATA 40 GB x 2 Drives (GBP 40 each)
Our concern is that this setup is going to cost us GBP 100 and give us 80GB. But we only will use 15GB and have concerns that with such a low volume we may be better off purchasing 1 single high performance drive instead.
So my question is: Purchase 1 high performance drive or implement RAID??? The costs are about the same.
(remember.. DB is only 15GB).
P.S I am aware of the draw backs of RAID 0.