Clustered SQL instance

Posted on 2013-05-30
Last Modified: 2013-05-31

we're in the process of deploying a clustered SQL 2008 R2 platform running on windows 2008. I'm toying with building our test infrastructure to mimic production - being clustered as well. This comes at an expense as it's more hardware. I'm trying to weigh up if this expense will be worth reducing the risks that I'd have by not having a clustered test environment. Can anyone give me some pointers, links to white papers/BOL, or other ideas and suggestions on this?

Thanks in advance
Question by:telliot79
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
  • 3
  • 2
  • 2
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 39209094
are you going with two physical servers, in that case try with VMs; that way you can reduce some cost;
Now, what are the reason you are going for another clustered environment, is it just for testing ? are you planning to run any reports ; can you give more information on this?
If it is just for testing, it wont actually worth the money to mimic the servers;

Author Comment

ID: 39209123
yep, we're going to use VMs to reduce cost. right now, we've not made our mind up on another clustered environment for test. my thoughts are that it would be a better place to install and test windows patches as we're running an OLTP database and it's critical that we don't have any downtime. it's just a discussion right now, and I'm measuring this small risk against the cost of building and maintaining this test clustered environment.

Author Comment

ID: 39209125
the test envirnment will also be vitualised, but we'll need to add more resources if we do go for a clustered environment there.
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

LVL 23

Accepted Solution

nemws1 earned 405 total points
ID: 39209384
If you are running clustered production it is *well worth* the extra costs in my book to run a clustered test environment (VMs are awesomely fine).

As for doing SQL/database changes, I found clustering to be a moot issue. (I'm talking about testing database-only changes).  You can test these on a single server (for the most part).  However, as you point out, having a clustered setup is *awesome* for testing OS & database patches/upgrades, since you can do so in the same method/manner as you will (eventually) upgrade your production servers.
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 39209489
Its mainly a business decision; How much money they can spend on this.
LVL 23

Expert Comment

ID: 39211597
I agree, it is a business decision.  The business should realize it is a gamble.  Maybe the upgrade will go fine.  Maybe it won't.  How much are you willing to lose if the upgrade does sour?  How much are you willing to spend to try to make sure that doesn't happen?  :)

Author Closing Comment

ID: 39211785
Thanks for the quick feedback.

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
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 …
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

630 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