Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Development server configuration(hardware) Expand / Collapse
Author
Message
Posted Saturday, November 22, 2008 9:11 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 16, 2013 2:48 PM
Points: 262, Visits: 1,503
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.
Post #607133
Posted Sunday, November 23, 2008 2:51 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:20 AM
Points: 6,281, Visits: 13,528
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"
Post #607158
Posted Sunday, November 23, 2008 6:55 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 16, 2013 2:48 PM
Points: 262, Visits: 1,503
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.
Post #607182
Posted Sunday, November 23, 2008 3:45 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 3:58 PM
Points: 361, Visits: 863
"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/
Post #607232
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse