CHAPTER 4

image

Much Ado About Indexes

The keys to a healthy SQL Server are healthy indexes, and therefore I’ll cover indexes in this chapter. This chapter is an introduction to indexes and does not deep dive into index internals. Instead, the goal of this chapter is to provide you with some useful index analysis scripts and methods so you can understand how indexes affect the performance of your SQL Server. The primary things you need to look at in terms of having a healthy index strategy and therefore a high-performing SQL Server are as follows: missing indexes, too many indexes, duplicate indexes, and fragmented indexes. You’ll look at index usage ...

Get Healthy SQL : A Comprehensive Guide to Healthy SQL Server Performance now with O’Reilly online learning.

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