SQL Clustering advantages

Posted on 2007-08-03
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

    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

    Thanks Tedbilly!  Sorry about the late reply.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Suggested Solutions

    by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
    Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    733 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

    26 Experts available now in Live!

    Get 1:1 Help Now