I have an SQL Server machine that i'm building and i'm going to have 1.5gb of data uploaded each week (divide that by 7, uploaded once a day) so write isn't *that critical... however, there will be a ton of reads - and some pretty massive queries spanning over a billion rows... I have a pretty serious budget for building this machine so i need to know the best solution for housing this database... right now i'm kind of torn between a couple solutions...
Dual Opteron 248 processor setup w/ 4-8gb of ram
4 76gb 15k rpm u320 scsi Fujitsu hard drives in Raid 5 or 10 for the data files
6 76gb 15k rpm u320 etc etc in raid 5 or 10
8 etc etc
any ideas? i expect nearly 100gb/yaer - and i need to be able to expand in the future... fault tolerance is a pretty serious issue as well - i can have *some downtime in order to rebuild arrays and what not - but if i lost that much data i'd be done for...
Another solution i was told about would be SAN? I know NOTHING about this... i just need fast Read I/O - in all of my benchmarks i've run on my app/server it's bottled at disk read I/Os.
Please advise - i need to make a decision w/in the next 48 hours...
i'm building a complementary asp.net web server and this sql server db will obviously be the source.