ReleaseUpdateTransformDB50_Admin.perfomanceBoostingHint Upgrade Script
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
Class |
ReleaseUpdateTransformDB50_Admin |
Method |
perfomanceBoostingHint |
Description |
Reminds the user to run the performance-boosting SQL scripts before preprocessing upgrade. |
Script Type |
Upgrade readiness scripts |
Microsoft Dynamics AX Source |
Microsoft Dynamics AX 2009 |
Affected Modules and Tables
Affected Modules |
|---|
Administration |
|
Validation Issues | |
|---|---|
|
Validation Issues Description |
During Preprocessing, updating the shadow tables’ statistics increases performance significantly. We should have a mechanism to run these scripts (direct SQL) as part of the preprocessing upgrade. That way, we can make sure customers are running the upgrade process on optimized tables. |
|
Checked Conditions |
N/A |
|
Mitigation/How-to-fix |
Reminds user to run the performance-boosting SQL scripts before preprocessing upgrade. |