Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

SQL Server Post SQL Installation Checklist (Part 4 of 4)


By:   |   Last Updated: 2008-06-29   |   Comments   |   Related Tips: 1 | 2 | 3 | 4 | More > Clustering

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, logs, full text catalogs and indexes), Sql Server program files path, Sql logging/tracing paths
Appropriate SQL Server service pack and hotfixes applied
SQL 2005 - Client tools installed individually on cluster nodes (if desired)
SQL 2005 - SSIS service installed individually on cluster nodes (if desired)
SQL 2005 - SSIS properly installed, configured, etc. for cluster use (if desired)
All SQL Server resources online and configured
Static port number assigned to the instance, protocols configured
Additional disk resources configured as dependencies of the SQL Server resource and verified (fn_servershareddrives or sys.dm_io_cluster_shared_drives)
"Affect the Group" option set correctly for Sql Server 2005 and Analysis Services 2005 resources
Advanced Security (IPSec, Kerberos, or SSL) enabled if appropriate
Verify possible owners list for ALL resources contains appropriate nodes
Preferred owners configured for more than two nodes
Resource group failback policy set (if modifications necessary)
Resource parameters set (if modifications necessary)
Resource group thresholds set (if modifications necessary)
Verify the failover of the SQL Server virtual server to and from all nodes in the cluster
Verify all applications with the failover of the SQL Server virtual server
Appropriate services marked to Not Affect Group and/or removed from cluster control (FTS, Backup drives, etc.)
Verify node participation for the instance (fn_virtualservernodes)
Model database reconfigured appropriately
Enable advanced configuration options
Default data/log file paths reset
Configure tempdb
Maintenance database created and configured on instance
Set appropriate default DB Options on system, model, and existing user databases (using DatabaseOptions.sql script if available)
Security configured appropriately (lockdown script if available)
Default server options configured appropriately (using ServerOptions.sql script if available)
SQL Agent properties configured
Standard jobs, alerts, monitoring systems, procedures deployed to system
Capture MPS Reports (cluster, Sql, Setup/Perf) for each node in the cluster
If desired, installation account (ideally the Cluster Admin account) can have privilege to ADD ACCOUNTS to each of the Domain Groups for Sql Server-related accounts revoked (no longer required)
SqlIoSim run to baseline disk subsystem health and configuration
SqlIo run to baseline throughput limitations of IO system
Clear event logs (if desired) and archiv0065
 

Last Updated: 2008-06-29


next webcast button


next tip button



About the author




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Learn more about SQL Server tools