Smart Re-Indexing - The quest of ultimate automation
Duration: 60 minutes
Track: Enterprise Database Administration & Deployment
How many times you have been called on weekends to handle a nightmare caused by Re-Indexing job? One of the most common aspect of performance tuning is a well-design dynamic index optimization process. If you ever wonder what it takes to design an efficient re-indexing process, which perform selective re-indexing, handles blocking automatically, 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 other words, fewer headaches. This session is for you!!