Apr 1st 2.45 pm, I will be presenting “Re-Indexing – The quest of ultimate automation” @ sqlsaturday, Orange County, if you are in the area I hope to see you…
location:
Golden West College, 15744 Goldenwest St,
Orange County, California, 92647, USA
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.
download scripts and presentation from github
SQL Saturday Session Evaluation
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 stop itself beyond a threshold
5. 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.
