MSSQLTips

A high percentage of my interactions with clients revolve around clustering SQL Server in some manner or another - could be to review a high-availability solution, could be to stand up a new clustered instance of SQL, could be to troubleshoot a system that is having stability issues, etc. In all cases...

Attached to this page is a zip file that contains completed samples (totally made-up data) of each of the informational gathering sheets referred to in my post about installing and configuring SQL Server within a clustered server. Contained within the zip are completed samples of: Info Sheet - Cluster...

This is the fourth and final checklist in the process – run through it just after completing a SQL Server installation in any environment. SQL Clustering Post-Installation Checklist Activity Pass Fail If antivirus software is installed, set filter to exclude all Sql extensions (data files, snapshots...

This is the third checklist in the process – run through it just before installing SQL Server in any environment. SQL Clustering Pre-Installation Checklist Check Pass Fail No errors that may interfere with install in Event Viewer SQL 2005 – Sql service account given the “lock pages in memory” local permission...

This is the second checklist in the process – run through it just after you form the cluster, or prior to installing SQL Server in any environment. Server Cluster Post-Installation Checklist Check Pass Fail Create MS DTC and configure completely Verify priority of cluster network(s) - all Private networks...

This is the first checklist in the process – run through it as soon as you are ready to form the cluster, or prior to installing SQL Server in a standalone-configuration. Server Cluster Pre-Installation Checklist Check Pass Fail Verify cluster hardware configuration on Windows Catalog/HCL Complete each...

{SERVERNAME} - Disk Configuration Basic/Internal Disk Information Attribute Value System Name Disk # and Info. Partitions Number of Internal Drives Size of Each Physical Drive Speed of Physical Drives Type of Disks (IDE, SCSI, Mixed) SQL Server Disk Information Attribute Value Are Files/Filegroups Used...

This informational sheet should be filled out completely prior to starting the installation/configuration of a new cluster or standalone instance. NOTE: Only include user/password information if secure document – if not, simply reference the location to retrieve. {SQL Instance Name} SQL Config Copy and...

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...

This is a standard outline of the process that should be followed for configuring and installing a new cluster for SQL Server use and one or more SQL Server instances (SQL 2000 and 2005 information included). The outline starts with reference materials at the top, followed by a general outline of the...