{"id":790,"date":"2010-02-04T00:00:00","date_gmt":"2010-02-02T00:00:00","guid":{"rendered":"https:\/\/test.simple-talk.com\/uncategorized\/mission-critical-sql-server-2008-performance-tuning-task-list\/"},"modified":"2021-08-24T13:40:32","modified_gmt":"2021-08-24T13:40:32","slug":"mission-critical-sql-server-2008-performance-tuning-task-list","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/databases\/sql-server\/database-administration-sql-server\/mission-critical-sql-server-2008-performance-tuning-task-list\/","title":{"rendered":"Mission Critical: SQL Server 2008 Performance Tuning Task List"},"content":{"rendered":"
\n
\"930-title.jpg\"<\/div>\n

CTL10.03.001<\/p>\n

Revision 09\/08\/2009 A<\/p>\n

SQL Server 2OO8 <\/p>\n

General Performance Tuning<\/p>\n

CRITICAL TASK LIST PROGRAM<\/b><\/p>\n

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.<\/p>\n

Review each item, placing a check in the “Confirmed” column  <\/span>when the task line is complete. Any line not marked “Confirmed” should stop the process until you have completed that line item.<\/p>\n

This CTL is not meant to be a replacement for the official documentation <\/span>from the product manufacturer.  <\/p>\n

CTL NUMBER <\/b><\/p>\n

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  <\/span>(identified by the date and an alpha-numeric code. <\/p>\n

HOW TO BE ASSURED OF HAVING LATEST DATA <\/b><\/p>\n

You can add additional information to this checklist based on your organization’s need.<\/p>\n

 <\/span>CONTENT <\/b><\/p>\n

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.<\/p>\n

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.  <\/p>\n

SUPPLEMENTS <\/b><\/p>\n

Official Site Link: <\/span>(Not available at this revision level)<\/p>\n

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. <\/p>\n

COMMENTS AND QUESTIONS <\/b><\/p>\n

Comments and questions should be directed through buck.woody@microsoft.com<\/a>. <\/p>\n

  <\/p>\n

Critical Task Lists Managers <\/p>\n

Buck Woody “Real World DBA”<\/p>\n

(MSFT U.S.)<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

Task<\/b><\/p>\n<\/td>\n

\n

Notes<\/b><\/p>\n<\/td>\n

\n

Confirmed<\/b><\/p>\n<\/td>\n<\/tr>\n

\n

Backups Checked, Full System Backups Complete.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/3IF34A<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
\n

Baseline Performance Metrics Created and Archived.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/1xtJk4<\/a> <\/p>\n

http:\/\/bit.ly\/2mwApK<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
\n

Server and Database Settings Configured for Environment.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/UvpbH<\/a><\/p>\n

http:\/\/bit.ly\/3RaZzF<\/a><\/p>\n

http:\/\/bit.ly\/WL7jc<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
\n

Latest Service Packs Installed.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/40JY5f<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
\n

Maintenance Wizard or other Automated Maintenance Implemented.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/16jnXG<\/a> <\/p>\n

http:\/\/bit.ly\/Wr82X<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
\n

Windows Event Logs Reviewed.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/6IaNH<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
\n

SQL Server Error Logs Reviewed.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/6IaNH<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
\n

Drive Space Checked.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/EJQoM<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
\n

Jobs History Reviewed.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/i1Jbd<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
\n

Indexes Updated.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/vmpz5<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
\n

Statistics Updated.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/Nmyia<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
\n

Indexes Reviewed.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/vmpz5<\/a><\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
\n

Long-Running Queries Reviewed<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/3yZ8P<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
\n

Service Packs and OS Security Bulletins Evaluated and Applied.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/40JY5f<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
\n

New Performance Baseline Recorded.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/rA0zI<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
\n

Performance Reviews Completed from Baseline Comparisons.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/rA0zI<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n
\n

Growth Predictions Created from Baseline Metrics.<\/p>\n<\/td>\n

\n

http:\/\/bit.ly\/1xtJk4<\/a> <\/p>\n<\/td>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

In which Buck Woody imagines how the US military would have tackled DBA checklists for ‘mission-critical’ databases. And having imagined it, lo, it came to be. The CTL for the DBA with short-back-and-sides.…<\/p>\n","protected":false},"author":221875,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[143527],"tags":[4168,4170,4150,4151],"coauthors":[],"class_list":["post-790","post","type-post","status-publish","format-standard","hentry","category-database-administration-sql-server","tag-database","tag-database-administration","tag-sql","tag-sql-server"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/790","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/221875"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=790"}],"version-history":[{"count":3,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/790\/revisions"}],"predecessor-version":[{"id":92272,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/790\/revisions\/92272"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=790"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=790"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=790"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=790"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}