The goal of the DBA Virtual Group is to provide a PASS community for the DBA. It provides a forum for open discussion and education on issues that face SQL Server database administrators.

Sign in to Subscribe

Re-Indexing – The quest of ultimate automation – sponsored by Dell Software

Wed, Oct 22 2014 16:00 UTC

Re-Indexing – The quest of ultimate automation – sponsored by Dell Software

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

Prakash Heda

Prakash Heda works as Manager (Data-IT) at SS&C Advent. His expertise encompasses the work of automation, performance tuning/troubleshooting, high availability, san configuration and windows administration. Heda has 13+ years of experience managing enterprise-wide data needs in both high volume transactional and data warehouse environments. Heda holds certifications for MCDBA and MCITP. His background includes administration & development using VB/ASP/SSIS with SQL server 2000 to 2017. He is an active member of PASS, SQLSaturday, and as well a frequent presenter at user groups, SQLSaturdays, and other community events. He is also an avid tweeter, blogger and runner.

Interested in Presenting at the DBA VG?

We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to DBA VG Leadership Team.

Want to become a member of the DBA VG Leadership team?

Members of this team moderate meetings and interact with the speakers during the Q&A sessions. Contact DBA VG Leadership Team, if you'd like to become part of the team.

Have a speaker to recommend?

Send the email address of the proposed speaker together with any relevant information about the speaker to DBA VG Leadership Team.


Meeting Recordings

The DBA Virtual Group presentations are recorded. On the Meeting Archive page, you will find  .WMV files that can be viewed on-line. Select the event you are interested in, click the Show More button if it is visible, and the recording and any associated files will be visible.

Back to Top