Solved

SQL 2008 R2 Clustering Hardware and Technology

Posted on 2011-03-07
2
246 Views
Last Modified: 2012-05-11
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
Comment
Question by:hh_techservices
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 13

Accepted Solution

by:
agarwalrahul earned 500 total points
ID: 35067151
0
 
LVL 1

Author Closing Comment

by:hh_techservices
ID: 35492774
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

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question