ReleaseUpdateTransformDB50_Admin.perfomanceBoostingHint Upgrade Script [AX 2012]
Updated: June 21, 2011
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 |
|---|
|
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. |
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).