
SQL Server Indexing for Performance
SQL Server performance is critical for business applications to meet internal and external customer needs. Unfortunately, one of the most common SQL Server performance issues is related to missing or incorrect indexes. Microsoft® SQLServer® is relatively unique because, as a database engine, it records missing indexes it thinks will help queries.
In this whitepaper, we’ll dive into the following:
- SQL Server indexing overview
- How to improve the quality and performance of your indexes
- Index information tracked by SQL Server, including index utilization, dynamic management views, the Query Store, and the execution plan cache
- SQL Server index options, including clustered, nonclustered, Columnstore, and XML
