Description:
when migrating large databases from big customers, we do see the last 2 steps DBCC UpdateStats and DBCC Defragment Indexes executed which costs a lot of time on big databases where you cannot use ADMS Console so the whole upgrade Process is taking longer
Challenge:
The upgrade process with big customers is time critical and done on weekends. Sometimes the weekend is getting too short for this update process. The last two steps are database related and such customers have their own maintenance plans on SQL Side, so ADMS Console would not necessarily need those 2 steps to execute within the upgrade locking the whole ADMS Console for those two steps.
Proposal:
Make those 2 steps optional like:
- skip Update Statistics and Defragment Database as I will run it later for optimal performance
Thank you
Johannes
