Recommendations for learning clustering

Question

Post reply

Recommendations for learning clustering

WayneS

SSC Guru

Points: 95460
More actions
April 25, 2009 at 9:56 am

#155607

I'm looking for recommendations (books, links, blogs, etc.) for learning about clustering, to include clustering with Sql Server and setting up / administering the cluster. Troubleshooting would be nice also.
Thanks!
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Alex Rosa Mr or Mrs. 500 Points: 562 More actions · Answer 1

I recommend you to learn about the concepts first and next learn about how to implement this kind of environment.

Windows 2003 Clustering

http://technet.microsoft.com/en-us/library/cc783714.aspx

Windows 2008 Clustering

http://www.microsoft.com/windowsserver2008/en/us/failover-clustering-overview.aspx

Pro SQL Server 2005 High Availability

http://www.amazon.com/Pro-Server-2005-High-Availability/dp/159059780X/ref=sr_1_1?ie=UTF8&s=books&qid=1240679522&sr=1-1

This is great book in my opinion, the book covers concepts and howto: Windows and SQL Server.

good luck.

---------------------
Alex Rosa
http://www.keep-learning.com/blog

BJ Cummings-783681 SSC Enthusiast Points: 101 More actions · Answer 2

It may also be helpful to setup a virtual environment to experiment with these concepts.

BJC

DKG-967908 SSCrazy Points: 2345 More actions · Answer 3

BJ is right, you can easily test this environment on Virtual Setup. You can create 2 or 3 virtual servers (depending the configuration or your machine/server) and easily test clustering/other high availability concept provided by MS.