Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Development server configuration(hardware)


Development server configuration(hardware)

Author
Message
Mh-397891
Mh-397891
SSC Veteran
SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)

Group: General Forum Members
Points: 264 Visits: 1514
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.
Perry Whittle
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8780 Visits: 16554
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" ;-)
Mh-397891
Mh-397891
SSC Veteran
SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)

Group: General Forum Members
Points: 264 Visits: 1514
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.
Kendal Van Dyke
Kendal Van Dyke
Old Hand
Old Hand (370 reputation)Old Hand (370 reputation)Old Hand (370 reputation)Old Hand (370 reputation)Old Hand (370 reputation)Old Hand (370 reputation)Old Hand (370 reputation)Old Hand (370 reputation)

Group: General Forum Members
Points: 370 Visits: 983
"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.

Kendal Van Dyke
http://kendalvandyke.blogspot.com/
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search