Solved

Clustered SQL instance

Posted on 2013-05-30
7
560 Views
Last Modified: 2013-05-31
Experts:

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
0
Comment
Question by:telliot79
[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
  • 3
  • 2
  • 2
7 Comments
 
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;
0
 

Author Comment

by:telliot79
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.
0
 

Author Comment

by:telliot79
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.
0
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

by:
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.
0
 
LVL 75

Expert Comment

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

Expert Comment

by:nemws1
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?  :)
0
 

Author Closing Comment

by:telliot79
ID: 39211785
Thanks for the quick feedback.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
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 backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

752 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