Index Tuning 101

Glenn Berry

Conventional row store index tuning is one of the most powerful and easy performance tuning methods available for database professionals. Finding and creating useful new indexes and dropping unused and duplicate indexes can have a profound positive effect on your workload. Index tuning is a low-risk method for improving query performance that is a readily available option with most databases. Despite this, many developers and DBAs struggle with index tuning tasks. This session shows you how to use DMV queries and Query Store to do more effective index tuning without making common mistakes. You will learn an easy and simple methodology for index tuning with a small set of diagnostic queries. You will learn how to safely create new indexes with the best index create options for your environment.