January 18, 2010 at 3:28 am
What are the prerequisites for SQL Server Clustering?What all do we require before thinking of clustering?
January 18, 2010 at 4:09 am
Read through all of the documentation on Technet on clustering. There's a lot of it. If you have specific questions once you've read it all, please ask.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 24, 2010 at 9:42 pm
This would involve what type of cluster you are planning.
Please read the BOL for more information. This checklist might help you.
Checklist for SQL Server 2008 64 Bit on Windows 2008 64 Bit (Active / Passive 2 Nodes)
===============================================================
?Type of cluster (Active/active or Active /passive)
?Number of Cluster Nodes
?OS version & Edition
?SQL Server version & edition
?Verify Your Hardware Solution (The hardware you select should listed in the Cluster Solutions section of the Microsoft Hardware Compatibility List (HCL), which can be found at ttp://www.windowsservercatalog.com/.)
?Verify the physical memory which should be same and more then 4 GB
?Verify the number of CPU in both nodes
?Verify Storage SAN/iSCSI
?Configure the quorum disk
?Create a Local Disk for Page File(Set the page file on the C drive to 1.5x physical memory, but check with your System admin)
?You need 0ne private network card with IP address for Heart beat Two public IP address on a separate subnet
?All NICs configured with same communication settings (speed, duplex, flow control, media type)
?Configure Accounts in AD (All nodes must be in the same Active Directory domain)
?Ensure that all cluster nodes are configured identically, including COM+, disk drive letters, and users in the administrators group
?Install .NET Framework 3.5 SP1 & Windows Installer 4.5.
?Verify that anti-virus software is not installed on your MSCS cluster
?Verify that you have disabled NetBIOS for all private network cards before beginning SQL Server Setup
?The Remote Registry service must be up and running
?Remote Administration must be enabled
"More Green More Oxygen !! Plant a tree today"
January 26, 2010 at 3:17 am
I would add:
Document the problem you are trying to solve. Then identify which of the HA solutions is the best fit for your problem.
Sometimes Clustering is the right answer, but also look at http://sqlcat.com/whitepapers/archive/2009/09/23/using-replication-for-high-availability-and-disaster-recovery.aspx before making your final decision.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply