You’re offline. This is a read only version of the page.
170
We have migrated the AX to Azure and changed the SQL Server 2014 to SQL Server 2016. The servers is better than the on premise servers, but the performance is so bad! The on premise servers were using the SQL Server 2014, but now is not possible to rollback the migration from SQL Server 2016 to SQL Server 2014. We did some tests, but nothing was detected before the Azure Go Live. We are working to create new indexes, but it is so strange. Anyone have had the same issue?
Thanks!
*This post is locked for comments
set max degree of paralllelism = 1 on DB level and enable trace flag 9481
Sql 2016 should be faster. However, how its configured for you we don't know.
I suggest review this help first: https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/lifecycle-services/ax-2012/plan-2012-r3-deployment-azure
Particularly these links
In general I have poor experience of azure - most systems I have seen have been undersized, and poorly configured.
For Azure VMs running on Windows Server® 2008 R2 and previous releases, the only striping technology available is striped volumes for dynamic disks. Storage space was a new function made available in Windows 8.0+ and Windows 2012+. Which are you using?
IO is key . so ensure that database settings consider how the IO can be reduced.
A standard disk in Azure has IOPs limits. A storage account has a maximum IOPs limit of 20,000. Avoid storing multiple heavily used data disks in the same storage account. Multiple data disks can be used to stripe storage space, or OS striping to increase the IOPs. You can create a single storage pool with 16 data disks. This helps provision 8000 IOPs for the volume. Exceeding the IOPs limit of the given volume would create random high latency.
If you have not configured the disk properly, then you will see error log messages:
You can also try the steps outline here: https://blogs.msdn.microsoft.com/axinthefield/dynamics-ax-performance-step/
Hi Andre! We are using the SSD Ultra (Premium).
Hi Rafael,
When using this machine type, you have choice to use standard HDD, a standard SSD or premium SSD for the disks. Ensure it is Premium SSD.
We are using the Standard_DS14_v2. This option has SSD disk.
Did you use Premium Storage (SSD) for the database servers? That's the first thing to check. I don't think your problem is related to SQL Server version, most likely it's something else. And the most common reason for general slowness in AX is poor disk performance of the database server.
You can use DynamicsPerf tools with PAL tool (Performance Analysis of Logs) to analyze the disk speed and many other things. Basically it uses Windows Performance Monitor to capture certain metrics and then generates a report for you.
Or you can just check the disk related counters yourself. Disk read/write wait time, disk read/write queue length for example.
Hi Rafael,
You have to start monitoring what could cause the issue. Is it latency, SQL server settings, indexes, storage or insufficient hardware resources? You can only find out by monitoring hardware resources and looking at SQL performance reports. You can also ask this questions on the SQL server forum as it is in fact not directly related to Dynamics AX.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (