I'm currently having trouble with a database server for a DB with lots of small writes and a few in comparison big reads. Read performance is more important because people is involved, writes are performed by automated clients. This database is currently 30GB and will grow up until a hundred or so.
The currently awful and ugly setup which underperforms is
- DELL Poweredge R300
- Quad Core Xeon X3353 @2.66GHz
- 14 GB RAM
- SAS 15k 146GB (two partitions, one OS, another Logs)
- SAS 15k 146GB (one partition, data and tempdb)
- No RAID (ugh)
- SATA 7k 1TB [via USB 2.0, external power supply, where daily backups are stored]
So, due to its many ugly points (underperforming, no RAID, external USB drive for backups) I'm planning to set up a new database server.
I've thought about:
- 4 SAS 15k 73GB RAID10 for logs
- 2 SAS 15k 73GB RAID1 for OS
- 4 SAS 15k 146GB RAID10 for data + tempdb
- 32GB RAM
So, three questions:
Is this the best price/performance combination? Is this overkill? Is there a better combination? Is more information needed?
Do you know of a reasonable priced single machine which can contain the 10 disks or must I go for an external locally attached storage right now?
Any recommendations for getting something like this at a reasonable price/quality?