Dynamic AX Database Tuning for Smith & Nephew

Smith & Nephew supports healthcare professionals in more than 100 countries in their daily efforts to improve the lives of their patients. Therefore their Dynamic AX system is shared by multiple business entity and requires very high performance. Prior tuning the database, we found that Dynamic AX creates the queries dynamically and all of them are Ad-Hoc basis therefore tuning such system from some other consultants are almost impossible. 

Our consultant performed the Instance & Database Configuration, Storage and Database Re-Alignment, Database I/O Balancing, Database Indexing, Query Design and Execution Analysis services to make sure SQL Server is aligned with Dynamic AX requests and hardware resources are utilized wisely.

[warning]Note: Be aware that Dynamic AX database performance tuning is subjective and services required are different case by case.[/warning]

The following figure shows one of query performance prior our performance tuning service:-

and the following figure shows the performance improvement on the same query after our services have been done. SQL Server created a new execution plan for the same query due to database index and statistics changes to improve the performance.

The Dynamic AX database performance improvement for this specific environment was about 70 percent which in some system functions improvement reaches 100 percent. Base on customer observation, the time spend on regular operations from 15-20 seconds drop to 5-7 seconds which the current performance latency is caused by Dynamic AX engine as it uses lots of cursors to fetch and calculate data.

 

 

Share This Story

Share on facebook
Share on twitter
Share on linkedin
Share on whatsapp

Share Your Comments

About The Author

Search Articles

Categories

Follow Fard Solutions

Share Your Comments

Fard Solutions Sdn. Bhd. Company was established in 2012 in Kuala Lumpur. We are engaged in development, implementation, integration and maintenance of the most advanced database solutions and IT research & development (innovation).

(+60) 03 8994 6788

info@fard-solutions.com

Fard Technology Corp.
700-1199 West Hastings Street,
Vancouver, British Colombia,
V6E 3T5 Canada.

Fard Solutions Sdn. Bhd.
1-1C & 1-2C Incubator 1,
Technology Park Malaysia,
Bukit Jalil, 57000
Kuala Lumpur, Malaysia.

  • Copyrights © 2020 Fard Solutions Sdn. Bhd. , All rights reserved.
  • Privacy Policy
  • Terms of Service
  • A Project By Website Artisan