Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL 2008 R2 Clustering Hardware and Technology

Posted on 2011-03-07
2
Medium Priority
?
249 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:
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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
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.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

670 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