SQL Server 2017 Query Performance Tuning: Troubleshoot and Optimize Query Performance

© Grant Fritchey 2018

Grant FritcheySQL Server 2017 Query Performance Tuninghttps://doi.org/10.1007/978-1-4842-3888-2_28

28. SQL Server Optimization Checklist

Grant Fritchey¹ 

(1)

Grafton, Massachusetts, USA

 

If you have read through the previous 27 chapters of this book, then you understand the major aspects of performance optimization. You also understand 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 ...