Re-Indexing - The quest of ultimate automation
On 27th Sep 03.15 PM EST, I will be speaking on “Re-Indexing - The quest of ultimate automation”@ SQLSaturday, Orlando, If you are in the area I hope to see you!!
PASS SQLSaturday’s are free 1-day training events for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. Whether you’re attending a SQLSaturday or thinking about hosting your own, I think you’ll find it’s a great way to spend a Saturday - or any day.
You will learn a dynamic index optimization process which…
- Do selective re-indexing
- Handles blocking efficiently
- Avoid system downtime due to log disk full
- Automatically stop itself beyond a threshold
- Can be implemented across all sql servers regardless of application type or data size
In this session, Prakash will walk you through design considerations, accompanied with a script demo using PowerShell to generate a dynamic re-indexing script , created based on his real-life experience from managing high performing database systems."