SQL Server 2OO8
General Performance Tuning
CRITICAL TASK LIST PROGRAM
This
document contains steps that will assist you evaluate the basic
Performance of a SQL Server 2008 RTM Enterprise Edition (non-clustered)
Instance. It defines the basics of creating and evaluating the
performance of a single Instance of SQL Server 2008, and should be used
as a starting point.
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
You can add additional information to this checklist based on your organization’s need.
CONTENT
Critical Task List 10.03.001 contains
steps required to perform performance tuning on a SQL Server 2OO8
system. Other system and environmental factors will dictate changes to
this CTL as well as additional steps that should be taken on a periodic
basis.
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: (Not available at this revision level)
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.
|
Task
|
Notes
|
Confirmed
|
|
Backups Checked, Full System Backups Complete.
|
| |
|
Baseline Performance Metrics Created and Archived.
|
| |
|
Server and Database Settings Configured for Environment.
|
| |
|
Latest Service Packs Installed.
|
| |
|
Maintenance Wizard or other Automated Maintenance Implemented.
|
| |
|
Windows Event Logs Reviewed.
|
| |
|
SQL Server Error Logs Reviewed.
|
| |
|
Drive Space Checked.
|
| |
|
Jobs History Reviewed.
|
| |
|
Indexes Updated.
|
| |
|
Statistics Updated.
|
| |
|
Indexes Reviewed.
|
| |
|
Long-Running Queries Reviewed
|
| |
|
Service Packs and OS Security Bulletins Evaluated and Applied.
|
| |
|
New Performance Baseline Recorded.
|
| |
|
Performance Reviews Completed from Baseline Comparisons.
|
| |
|
Growth Predictions Created from Baseline Metrics.
|
No comments:
Post a Comment