Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MS SQL Server 2008 Clustering

Posted on 2012-03-30
1
Medium Priority
?
195 Views
Last Modified: 2012-04-10
Hi,
I am looking for a details on how MS windows clustering works forSQL server clustering.

What is shared nothing architecture? What is Quorum?

Thanks
0
Comment
Question by:crazywolf2010
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 2000 total points
ID: 37794105
As a general overview, here's my favorite walk-through, which takes you through clustering Windows Server and then clustering SQL Server on top of it, and explains the steps in a reasonable amount of details as it goes along:

http://dbperf.wordpress.com/2010/07/10/walkthrough-cluster-setup-sql-win-2008/

There's also a brief walk-through/explanation on this MSDN blog that gives some more details, though it's not SQL Server specific:

http://blogs.msdn.com/b/clustering/archive/2008/01/18/7151154.aspx

To your specific questions, though:

Shared Nothing: This just means that there's no single component whose failure would cause downtime for a clustered application. For example, in a two node cluster with a quorum drive, a failure of the quorum disk (or the connection to it) would cause a failure of the clustered applications. However, if you add a third node to the cluster, it can fall back to node majority using networking, so you gain some reliability.

What is quorum: Usually this is a physical disk (a LUN on your SAN or a shared disk in your drive cage) that the cluster nodes use to help determine who is in charge of what applications (they also use the network, but the disk exists as a fallback). Clustering Windows Server, at least in the default configuration, requires a Quorum disk. You can switch the cluster model to "node majority", but there are risks involved, especially for smaller clusters.

What are you wanting to learn - how clustering works as a concept, the specific aspects of how clustering impacts SQL Server's operation, or something else?
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

721 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