SQL Clustering advantages

Posted on 2007-08-03
Medium Priority
Last Modified: 2013-11-05
Does a SQL Cluster using Windows Enterprise 2003 and SQL Cluster 2005 support only FAILOVER, or does it also allow LOAD-BALANCING?
Question by:cliffordgormley
LVL 51

Accepted Solution

Ted Bouskill earned 1000 total points
ID: 19629952
It does not support load balancing.  However, there is a trick you can use to make better use of the servers.

Most examples, describe an Active/Passive scenario which means that one server is live (Active) and the other is a hot standby (Passive).  So if the Active server goes down services are transferred to the Passive server.  Each server has one instance of SQL.

The trick I did was setup a Active/Active setup.  In this case there are four instances of SQL!  There is one active instance on each server and one passive.  Each server is the passive copy of the other server.

I then split the load by putting different databases on each server.  One has reporting databases (datamarts) and the other runs the application databases.

To be honest though I hired a consultant to do it.  It took him one week including documentation, setup and testing.

Author Comment

ID: 19714436
Thanks Tedbilly!  Sorry about the late reply.

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

850 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