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_15

15. Monitoring Indexes

Edward Pollack¹   and Jason Strate²

(1)

Albany, NY, USA

(2)

Hugo, MN, USA

 

Throughout this book, many topics have been discussed, such as what indexes are, what they do, patterns for building them, and many other aspects for determining how a SQL Server database should be indexed. All of that information is necessary for the final piece in indexing your databases: analyzing databases to determine which indexes are required. The final three chapters in this book will pull together the information needed to implement ...