CTL10.06.001
CTL10.07.001
Revision 5/12/2010 A
SQL Server
General Configuration
CRITICAL TASK LIST PROGRAM
This document contains steps that will assist you in the completion of and review of the configuration of a non-clustered SQL Server RTM Enterprise Edition software Instance.
Review each item, placing a check in the “Confirmed” column when the task line is complete. Any line not marked “Confirmed” should stop the process until you have completed that line item.
This CTL is not meant to be a replacement for the official documentation from the product manufacturer.
CTL NUMBER
This Critical Task List is identified by a CTL number in the upper right-hand side of this document. You should use the latest CTL (identified by the date and an alpha-numeric code.
HOW TO BE ASSURED OF HAVING LATEST DATA
Refer to http://www.simple-talk.com/author/buck-woody/. You can also add additional information to this checklist based on your organization’s need.
CONTENT
Critical Task List 10.07.001 contains steps required to properly evaluate the basic configuration for a SQL Server Instance. Since each setup is unique for the specific use of the Instance, references are provided for the proper choices. This checklist represents the bare minimum checks for configuration, and each choice should fit the desired purpose and use of the system.
All content is the sole responsibility of the server owner; Microsoft Corporate provides no warranties implied or implicit in this document. This document is not a product of the Microsoft Corporation.
SUPPLEMENTS
Official Site Link: http://www.simple-talk.com/author/buck-woody/.
Whenever you receive a supplement affecting your checklist, write in the appropriate information. Printed replacement checklist pages will be made available to you as quickly as possible. A notation on the bottom inside corner of these pages will indicate that they reflect certain supplements.
COMMENTS AND QUESTIONS
Comments and questions should be directed through buck.woody@microsoft.com.
Critical Task Lists Managers
Buck Woody “Real World DBA”
(MSFT U.S.)
|
Task |
Notes |
Confirmed |
|
1. Reviewed purpose and requirements of this Instance with all stakeholders. |
|
|
|
2. Reviewed Windows Event Logs. |
||
|
3. Backed up Windows System (where possible/feasible). |
||
|
4. Database Maintenance reviewed and run, evaluated for successful completion. (Backups at this point optional) |
||
|
5. Created all system configuration documentation, noted all Instance names and contact information. |
||
|
6. Performance Baseline run. |
||
|
7. Evaluated applications connected to system, notified users of downtime and other impacts. |
||
|
8. SQL Server Best Practices Analyzer (BPA) executed (SQL Server 2000 and 2005), or Best Practices Policy Based Management policies (SQL Server 2008 and higher) run. |
||
|
9. Results from BPA reviewed and researched, applied where appropriate. |
||
|
10. Minimum and Maximum memory set (to same number if possible), leaving at least 1GB for the OS. |
||
|
11. All processors selected for SQL Server unless otherwise needed by other functions, according to licensing model. |
||
|
12. Appropriate security model selected for Instance. |
||
|
13. Desired auditing level and compliance levels set for logins, noted in security documentation. |
||
|
14. Connections reviewed for defaults and for desired setting for remote access by client logins. |
||
|
15. All databases (including System databases) set to no autoshrink and no autoclose. |
||
|
16. All databases set to have owners. |
||
|
17. System Documentation updated. |
||
|
18. Allowed test users back into system, completed unit tests. |
||
|
19. Allowed all users back onto system. |
||
|
20. Complete work-cycle monitored for use. |
||
|
21. Performance Baseline run, compared. |
Load comments