Fast Guide: Clustering in SQL Server

Clustering can increase reliability and uptime in a client/server environment. As a DBA, you have many options to choose from when it comes to clustering. When a server fails, should you totally rely on a complete fail-over design? What's the best way to approach load balancing? Let this fast guide help you find the best fit for your environment.

Clustering can increase reliability and uptime in a client/server environment. As a DBA, you have many options to choose from when it comes to clustering. Choices include what to do when a server is failing or getting bogged down, do you want another to take over full operation or just some of its tasks? Will it be a complete fail-over design or just load balancing? What's the best way to minimize downtime? This fast guide will help...

direct you towards the clustering design fit best for your environment.

Is clustering for you?

  • Why cluster?
    There are two types of clustering in SQL Server: load balancing and failover. This short article examines the reasons for clustering and some of the system requirements.

Clustering options

  • Hardware clustering vs. replication: A case study
    This tip is based upon a real-life experience in a Tier 1 bank. We used Sybase tools like ASE and Replication Server but this case is very applicable to other engines such as Oracle with Data Guard, etc.
  • How does failover clustering work in SQL 2005?
    Learn how the failovThe following was based upon a real-life experience in a Tier 1 bank. We used Sybase tools like ASE and Replication Server but this case is very applicable to other engines such as Oracle with Data Guard, etc.er clustering functionality has been extended in SQL Server 2005.
  • Microsoft clustering algorithm
    Learn more about Microsoft's clustering algorithm, which is a segmentation algorithm provided by Microsoft SQL Server 2005 Analysis Services (SSAS).

Availability measures in clustering

  • SQL Server clustering best practices
    SQL Server clustering provides high availability to clients by sharing server resources over several nodes, but only when all of its dependencies are addressed.
  • Configuring High Availability
    This section introduces several Microsoft SQL Server 2005 high-availability solutions that improve the availability of servers or databases. Check out these options that will minimize downtime for users.

Clustering and installation

  • Configuring SQL Server clusters
    SQL Server Expert Adam Machanic recommends two books on the topic of high availability to help install SQL Server on two systems with the same database and the same database structure.
  • Setting up SQL Server clusters on a SAN
    Storage area networks (SANs) allow you to connect expandable storage to your SQL Server installations, but care must be taken when working with SQL Server clusters.
This was first published in August 2006

Dig deeper on SQL Server High Availability, Scalability and Reliability

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close