Andy Yun
sqlbek.wordpress.com
Andy Yun is a SentryOne Principal Solutions Engineer and a former Microsoft MVP, who has been working with SQL Server for nearly 20 years as both a DB Dev and Admin.
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.
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.