June 4, 2003 at 7:47 am
I've been tasked to provide 3 scenarios for new hardware purchage and configuration for a production SQL Server - a high, medium, and low end option. Anyone have any suggestions about resources (books, especially helpful web sites) to get started on this?
June 6, 2003 at 4:11 am
Cross,
It's you versus the bean counters. I can't tell you what to do, only what I'd do in the same situation.
For the low end scenario I would go for the minimum spec that I would accept, NOT the minimum spec that accounting will accept. If management want to shave things thereafter then it's their decision.
At the low end I'd start with a SQL Standard Edition server that has the capabilities to deal with the expected load, plus an appropriate RAID level (maybe 5) and the ability to shift database backups and log backups either to another server or offline backup media on a regular basis.
Once you've covered the "needs" with the low end spec, go for some of the "wants" such as RAID 10 for robustness plus performance, maybe SQL Enterprise Edition for some of those extras that you'll use every few months (indexed views, log shipping, etc).
At the high end, throw in the things that Finance will laugh at - clustered servers, failover servers with EE log shipping, SAN, blah blah.
Cheers,
- Mark
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply