• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 254
  • Last Modified:

SQL 2008 R2 Clustering Hardware and Technology

My first question has to do with the hardware for a SQL cluster. I plan on having a two server cluster in my datacenter and currently I have a pretty powerful HP DL585 G6 server with quad processors. At this time I do not have a budget to purchase another one, but will have a left over HP DL385 G6 server that I can use. I will be able to put the same amount of RAM in the server as the DL585, but the only difference will be the number of processors. The 585 has 4 and the 385 has 2. Is this an issue? I know if I was maxing out the DL585 that if we went to the DL385 I could see some performance issues, but we are not even coming close to maxing it out. Currently our total DB size of all DB's to be hosted is not even around 100GB at this time.

Second question. On top of wanting to put a cluster in our datacenter, I also want to do something with cluster for DR reasons. I have a new DR site that is being built and it is connected with a 1GB fiber connection to our corporate datacenter. So I've looked at some presentations and whitepapers, but I'm not a SQL expert by no means. With this setup what could I do that would ensure the greatest availability? Log shipping, mirroring, expand cluster to DR site.......

I've looked at the Microsoft Technical Article called "Proven SQL Architectures for HA and DR" and it shows 5 different examples, but I'm not for sure which is best because of my lack of knowledge.

Thanks for all the help.
0
hh_techservices
Asked:
hh_techservices
1 Solution
 
hh_techservicesIT DirectorAuthor Commented:
I could find the links, but I was looking for a more direct answer. I was able to find it somewhere else.
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now