Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AX 2012 R2 slow perfor...
Microsoft Dynamics AX (Archived)

AX 2012 R2 slow performance since convert to Virtual Machine of Database Server. Please help !

(0) ShareShare
ReportReport
Posted on by Living Color 130

Dear all,

Everything is OK before. But since we have converted hardware server of Database to Virtual Machine by Vmware Environment. Then AX 2012 R2 system have problem about slow performance although we increased more RAM, CPU, Hardisk,... for Virtual server

When run AX, many users (about 80 active users) sometime stuck "Not Responding" when open a form, post... AX and "start AX Client very long time" . We have follow and checked at that time:


1.RAM, CPU of Virtual server only used about 50% (CPU: Xeon Silver 4110 2.1Ghz, 2 socket - 8 processor ; Ram: 64GB ; Disk C: 300GB ; D: 2TB)


2.Performance of SQL server (Processor, Database I/O,...)

screenshot.50.jpg


3.Network bandwidth between AX Client and AOS Server, AOS Server and Database Virtual server all OK.


4.Checked the System Logs, it's not have special


5.Restart both AOS and Database Server

We don't know the reasson why. Someone can show me an advice or help me find a solution in this case.

I appreciate your help. Many thanks.

Regards.

*This post is locked for comments

  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,877 on at
    RE: AX 2012 R2 slow performance since convert to Virtual Machine of Database Server. Please help !

    Microsoft officially does not support vms on a production server.

    Ax performance is mainly about iops. There are iops between VMS that increase the traffic so that increases the problem.

    Almost certainly your Maxdop is set it too low i.e. 0 or 1 - try making it higher  2 or 5,  and Cost of Parrelism Threshholds are set too low probably a  defult of 5  (50 is a good start number to rry  for VMS). (Most of the recommended settings for these are based on older versions of sql and without vms.)

    Generally I would separate logs and database to different drives etc but in vs, they are better together otherwise there are extra iops.

    There are  many other factors which would require a proper system audit to advise on. 

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: AX 2012 R2 slow performance since convert to Virtual Machine of Database Server. Please help !

    Most likely the disk system is too slow.

    You can try to run some disk speed measurement tools to compare between your old database server and the new virtual server. I'm almost certain that you find out a big difference there.

    The solution is to improve your disk system performance, for example by using SSD disks.

    One good tool for finding issues is the DynamicsPerf tool: github.com/.../releases

    I suggest you set up collectors in Windows Performance Monitor, by using the templates provided by DynamicsPerf. Then you can generate a report of those recordings with the PAL tool (Performance Analysis of Logs), also shipped with DynamicsPerf. Then you get a clear list of things that are not performing well (such as disk read, disk write etc).

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans