Session 3: Index Tuning Foundations

Presented by: Ben DeBow

Running Time: 59 min

Last, but certainly not least, any DBA worth his or her salt knows that one of the most important methods for achieving good performance is to have the right indexes. An index is like a map for your queries – the right one can direct the query to a specific bit of data quicker. Without it, SQL Server will search until it finds the data. Instead of leading the relational engine on an archeological dig, this session will discuss how DBAs should approach an indexing strategy. When and where do you need them? When is an index effective and when can it be removed? How will having benchmarking and baselining help paint a picture of a database or instance’s performance? These and other topics will be addressed so that you look like an index hero.