Expert Performance Indexing in Azure SQL and SQL Server 2022: Toward Faster Results and Lower Maintenance Both on Premises and in the Cloud

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

E. Pollack, J. StrateExpert Performance Indexing in Azure SQL and SQL Server 2022https://doi.org/10.1007/978-1-4842-9215-0_16

16. Index Analysis

Edward Pollack¹   and Jason Strate²

(1)

Albany, NY, USA

(2)

Hugo, MN, USA

 

In the previous chapter, we discussed what information should be collected when monitoring indexes. All of that information is necessary for the next process of indexing databases, which is determining which indexes to apply. In this chapter, we will take all the information gathered while monitoring and use it to analyze the state of performance and the value of the existing indexes. The end goal of the index analysis is to build a list of indexes ...