November 22, 2008 at 9:11 pm
We have like about 5 different db's, the size of those db's is approx. over 400GB each. I am trying to prepare the hardware config which we need for this development server which will have these 5 databases. We will be having 2 drives one for data and the other one for log files. What's the best practice for the development server hardware config? Thanks.
November 23, 2008 at 2:51 am
is it absolutely necessary to have dev databases that large??
at most a small subset of data is usually good enough, 400GB is a bit OTT.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 23, 2008 at 6:55 am
Perry Whittle (11/23/2008)
is it absolutely necessary to have dev databases that large??at most a small subset of data is usually good enough, 400GB is a bit OTT.
I agree with that, I shall only have subset of data for our dev environment. Please let me know what hardware will be enough(like cpu's, memory etc) so that I can tell our IT. Thanks.
November 23, 2008 at 3:45 pm
"enough" is relative to what you want to do. If this is a development environment and you're trying to test functionality then you don't need a lot of horsepower. On the other hand if you're load testing and need to simulate production strain you will want something that matches what you're got in production. You should also consider what kind of redundancy your system needs. If this is "just development", you don't care if the box loses a power supply, and you don't need massive horsepower you could consider going with something like a quad core PowerEdge 860 with 4 GB RAM, no RAID, and get a next business day hardware support plan.
A lot of people nowadays are buying higher end machines and going the virtualization route. A PowerEdge 2950 with SAS drives, a RAID controller, and 16 GB of RAM can be virtualized into 3 or 4 machines. Not only do you get redundancy but you can get more bang for the buck by stretching your hardware out.
* Note I have no affiliation with Dell. We use them at work so I am just throwing them out there as a point of reference.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply