Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL 2008 R2 Clustering Hardware and Technology

Posted on 2011-03-07
2
Medium Priority
?
252 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
2 Comments
 
LVL 13

Accepted Solution

by:
Rahul Agarwal earned 1000 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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

916 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