Main Content

Re-Indexing – The quest of ultimate automation

A talk by Prakash Heda

About the Talk

April 1, 2017 2:45 PM

SQLSaturday

SQLSaturday

How many times you have been called on weekends to handle a nightmare caused by Re-Indexing job? One of the most common aspects of performance tuning is a well-design dynamic index optimization process. In this session, Prakash will walk you through what it takes to re-design existing re-indexing process which takes it to the next level, created based on his real-life experience from managing high performing database systems. You will learn a dynamic index optimization process which… 1. Do selective re-indexing 2. Handles blocking efficiently 3. Avoid system downtime due to log disk full 4. Automatically stops itself beyond a threshold 5. Can be implemented across all SQL servers regardless of application type or data size

Ratings and Recommendations

This Talk hasn't been rated yet. Sign In to rate Talks.

comments powered by Disqus