SQL 2008 R2 Clustering Hardware and Technology
Posted on 2011-03-07
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.