web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
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 132

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

I have the same question (0)
  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,886 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,160 Moderator 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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Mea_ Profile Picture

Mea_ 4

#3
howalker Profile Picture

howalker 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans