Solved

Clustered SQL instance

Posted on 2013-05-30
7
531 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
  • 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

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.
A safe way to clean winsxs folder from your windows server 2008 R2 editions
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…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

919 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now