I use a large SQL database (about 5GB+ could grow to 10GB+ or more) that several pieces of software access. What is the best hard drive solution to optimise access speed? I've been considering 10k or 15k drives in RAID0. I will make weekly backups, but the data is not critical so the array failing is not the end of the world. What matters here is performance.
High performance hard drive solution
- Thread starter Badgerpoo
- Start date
- Joined
- 2 Aug 2005
- Posts
- 8,721
- Location
- Cleveland, Ohio, USA
15K SCSI drives in the striped RAID of your choice.
What's the wokload on the database? If you want the best real world performance then you need to look at whether moving the logs off to a separate drive or array will be of benefit or whether there is concurrent access to multiple tables which would benefit from splitting the data across multiple tablespaces on their own drive/arrays.
If you have concurrent reads and writes then I would certainly consider splitting the logs from the data that way you minimise the I/O impact of the two phase commits in the writes.
I assume that you're looking at a serious amount of RAM in this box too?
I assume that you're looking at a serious amount of RAM in this box too?
1. DB Design/indexing
2. memory for reducing cache churn
3. Drive allocation for tasks - seperate arrays for logs, table spaces, indicies etc.
4. Fast hardware - 15K scsi, hardware raid controllers with cache memory, silicon discs for logs etc.
Use the metrics to show where the bottlenecks are.
2. memory for reducing cache churn
3. Drive allocation for tasks - seperate arrays for logs, table spaces, indicies etc.
4. Fast hardware - 15K scsi, hardware raid controllers with cache memory, silicon discs for logs etc.
Use the metrics to show where the bottlenecks are.