Solved

Clustered SQL instance

Posted on 2013-05-30
7
541 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

776 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