SQLBits 2018

Uncovering Duplicate, Redundant, & Missing Indexes

Ensure your indexes are achieving their fullest potential!
Do you know if your database's indexes are being used to their fullest potential? Know if SQL Server wants other indexes to improve performance?

 

Come and learn how SQL Server tracks actual index usage, and how you can use that data to improve the utilization of your indexes. You will be shown how to use this data to identify wasteful, unused, & redundant indexes, and shown some performance penalties you pay for not addressing these inefficiencies. Finally, we will dive into the Missing Index DMVs and explore the art of evaluating its recommendations to make proper indexing decisions.