Slow Performance

(0) Share

Report

Posted on by Community Member

I was hoping that some of the AX experts that frequent this forum could possibly shed some light on performance issues we are having in DAX environment. So a little bit about our environment, we recently upgrade to AX 2012 R3 CU10 from AX4.0 SP2

Database Server: SQL Server 2014 Standard Edition, 16 vCPU and 128 GB RAM. Storage is connected via 16GB fiber channel, Logs, Data and TempDB separated.

AOS Servers: (6) AOS Servers 4 vCPU and 12GB RAM

Batch Servers: (2) Batch Servers 4 vCPU and 12GB RAM

We have set trace flags, do proper backups and index maintenance and have followed numerous blogs and forum posts for best practices but we still see slow performance.

I am sure I am missing some of the details so please ask,

Hoping someone can shed some light on an area I may have missed or things that have worked for them.

*This post is locked for comments

I have the same question (0)

All responses (17)

Answers (0)

André Arnaud de Cal... 301,079 Super User 2025 Season 2 on at

Like (1)

Report

Hi abergsbaken,

You have to start measuring if hardware resources could be a bottleneck. What type of storage do you have for the AX databases and the tempDB? What is the power plan of the servers? If it is set to power save, there will be a real issue.

Can you also tell what exactly is slow in this environment and when? Is it opening forms, some batch processes, reports? Please elaborate. Do you have customizations?

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi Andre,

Thank you so much for replying!

We are currently running a fully virtualized environment, the storage is a Lenovo v5030 SAN. RAID is set according to MS specs. We have also tried standing up a physical SQL server with internal storage SSD for temp etc and we didn't not get any improvements. We have worked with our AX partner as well as MS and neither have come up with a solution.

Power plan is set to high

Everything is slow, open the client, changing between forms, entering data. Sales order / Purchases orders etc

I will mention we do have a rather large DB, 900GB about 40 companies

Was this reply helpful? Yes No
BorisD 2,826 Moderator on at

Like (1)

Report

I have noticed slowness usually relates to SQL Server CPU usage being pegged. how often are you doing maintenance in your environment? There might be bad queries out there pegging your CPU usage on the SQL server. Normally restarting AOS services can help with this. That's why I ask how often you do restarts/Maintenance.

Was this reply helpful? Yes No
Chandra Wijaya Seti... 1,145 on at

Like (1)

Report

Hi Abergsbaken,

Performance issue will have many variable.

First thing you need to pin down what is bottleneck.

1. Network

2. Database, well this is has topic has its own.

In highlevel is it dedicated sql server for AX, i suppose yes.

3. AOS for user (how many users are assigned into single AOS, if you use load balancer just divide max. concurrent user / 6 AOS you have). you identify also how much memory usage.

4. Batch AOS. How many batch processing in one server. Any heavy process like EDI, interface etc which lock down those table SO and PO.

5. You dont mention where is your SSRS server reside. If you have many users generating reports, then your SSRS sitting same with your SQL DB then it can affect performance.

In my opinion you should start with performance log for dynamics AX and engage one expert on AX performance troubleshooter.

technet.microsoft.com/.../jj149695.aspx

Then what is your OS for each server. i know the SQL 2014 std edition have max. 128 gb but make sure the OS has supported the max. memory too. It is unlikely but just in case you have special windows server version.

Then once you suspect or find the bottleneck you can get zoom in.

As per your description now it seems you dont know the bottleneck yet so it is too broad for anyone to help.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

We used to do nightly reboots of AOSs/SQL however Microsoft recommended we went to monthlys

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Network - We have tried with an AOS and the SQL on the same VMware host using VMXNET3 NICs so getting 10gb speeds within the host. While we are able to transfer files between the VMs very quickly using the client from AOS is still slow

Database - Yes this is a dedicated SQL Server instance for AX, 16cores as that is the max for SQL 2014 Standard and 128gb ram 96 dedicated to SQL

AOS - we have about 200 ish concurrent users during the workday spread on 6 AOS machines. However we see this slowness on the weekends or after hours as well when no one is on the system

Batch - We have 2 dedicated batch servers no batch jobs are ran during the day expect some MRP at times

SSRS - Does reside on the SQL Server

We have used all the tools suggested, we have dynperf running as well.

When we had Microsoft involved they suggested new servers with at least 3.2Ghz processors because in the AX trace logs they were seeing long execution times on the x++ code, so we bough new servers reran the test the code is executing faster however the end user doesn't notice a thing.

Was this reply helpful? Yes No
BorisD 2,826 Moderator on at

Like (1)

Report

abergsbaken,

How are your SQL backups scheduled and are they completing successfully. If backups get stuck they can hold up resources and cause slowness. If they are stuck stop and clear the stuck jobs. When you do a restart of the AOS's do you notice that things speed up temporarily?

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Full backups done nightly and Logs are every 15 min

No, after the AOS reboot its generally even slower till the cache build back up

Was this reply helpful? Yes No
BorisD 2,826 Moderator on at

Like (1)

Report

Do you have any other backups running other then SQL backups? like Backup Exec or other third party.

Was this reply helpful? Yes No
Okay Akdeniz 110 on at

Like (1)

Report

All AOS, Terminal, SQL Server servers' Power Options value must be set as "High"

support.microsoft.com/.../2207548

Change VM Ware physical bios value

kb.vmware.com/.../search.do;cmd=displayKC&externalId=2008925

Change Receive Side Scaling value set as "Enabled"

Check Latency on SQL Server Live on Performance Monitor/Network/Latency

Was this reply helpful? Yes No