Identify and resolve SQL Server problems BEFORE they happen with SQL diagnostic manager

SQL Server Cluster Node Configuration Checklist

By: Chad Boyd | Read Comments | Print Chad is an Architect, Administrator and Developer with technologies such as SQL Server, .NET, and Windows Server. Related Tips: More

This informational sheet should be filled out completely prior to starting the installation/configuration of a new cluster or standalone instance. 

{Node1 Name} Node Configuration

          Copy and paste this entire page/section and complete for each node in the cluster.

Parameter	Value
Node Number
Memory
# of ProcessorsMake, model, steppingMuti-Core, HT, etc.
Server Name
Owner of Groups
Public IP Address(es)
Public IP Subnet(s)
Public IP(s)	Network Name:  Client access only (public network) All communications (private and public networks)
Speed of Public NIC(s)
Public Teaming Info
Public Gateway
Public DNS Servers
Public DNS Suffixes
Public WINS Servers
Private IP Address(es)
Private IP Subnet(s)
Private IP(s)	Network Name:Internal cluster communications only (private network)
Speed of Private NIC(s)
Private Teaming Info
Private Gateway
Private DNS Servers
Private DNS Suffixes
Private WINS Servers
Private Connetion Type          Crossover cable?          Switch?

Related Tips: More | Become a paid author

Last Update: 6/28/2008

Share:

Share

Tweet

Free SQL Server Learning Building Blocks for Your SQL Server Career Database development best practices What Are You Waiting For?

Comments and Feedback:

Post a Comment or Question

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name

*Email

Notify for updates

Comments *** NOTE *** - If you want to include code from SQL Server Management Studio (SSMS) in your post, please copy the code from SSMS and paste the code into a text editor like NotePad before copying the code below to remove the SSMS formatting.
*Enter Code

 

Sponsor Information

"SQL doctor ROCKS! As soon as I ran it, problems that have been giving me headaches were identified and cured." Optimize your SQL Server storage: compress live databases by up to 90%. Download a free trial. Do you need some help to solve SQL Server problems you are facing? Solving SQL Server problems for millions of DBAs and Devs since 2006. Join now. Top 10 Tips for Optimizing SQL Server Performance - Check it out!