Chapter 16. SQL Server Optimization Checklist

If you have read through the previous 15 chapters of this book, then by now you understand the major aspects involved in performance optimization and that it is a challenging and ongoing activity.

What I hope to do in this chapter is to provide a performance-monitoring checklist that can serve as a quick reference for database developers and DBAs when in the field. The idea is similar to the notion of tear-off cards of "best practices." This chapter does not cover everything, but it does summarize, in one place, some of the major tuning activities that can have quick and demonstrable impact on the performance of your SQL Server systems.

I have categorized these checklist items into the following sections: ...

Get SQL Server 2008 Query Performance Tuning Distilled now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.