Microsoft Dynamics AX (Archived)

Time to execute retail jobs

(0) Share

Report

Posted on by Hassan_rulz

3,801

Hi All,

Its take more than 2 hours to execute all (9999) jobs for one store in our environment. Is it normal?

If not then how can we optimize it?

We are using AX 2012 R3 CU11 and SQL server 2014 SP2.

Regards,

Hassan

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

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

Like (0)

Report

Hi Hassan,

How many items and customers are involved? Are you monitoring your hardware and SQL machines for performance counters ( e.g. fragmemted indexes, long running queries)

Do you have customizations or partner solitions in this area?

Was this reply helpful? Yes No
Hassan_rulz 3,801 on at

Like (0)

Report

Hi Andre,

There are around 3500 customers and 20000 items involved.

Yes, I am monitoring hardware and SQL. Everything is behaving normally. AX client goes into not responding state and it uses less than 5% of CPU. Sometime even it also shows that it is using 0% of CPU.

Yes we have customization also.

Regards,

Hassan

Was this reply helpful? Yes No
Hassan_rulz 3,801 on at

Like (0)

Report

Hi Andre,

Any more tips?

Regards,

Hassan

Was this reply helpful? Yes No
CattermoleS 55 on at

Like (0)

Report

Hi Hassan,

have you tried running 9999-All Jobs in Batch as opposed to running from the client? Any errors in the event logs? Have any download sessions been created whilst the Client is frozen?

Regards,

Steve

Was this reply helpful? Yes No
Hassan_rulz 3,801 on at

Like (0)

Report

Hi Steven,

Yes, we have tried it with batch jobs also. No errors.

Download sessions are also being created while the client is frozen.

Regards,

Hassan

Was this reply helpful? Yes No
André Arnaud de Cal... 301,088 Super User 2025 Season 2 on at

Like (0)

Report

Hi Hassan,

What about the SQL performance monitoring? Is this giving some information? Did you also check hardware resources usage on the AOS servers?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi hassan,

Check retail channel database,possibility is changed in table /column /width compare you retail channel database ax. schema table to ax dbo tables....................... exclusive check inventdim table.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

may be a network issue, you need to investigate network topology and optimize it firstly

Was this reply helpful? Yes No
Hassan_rulz 3,801 on at

Like (0)

Report

Hi Andre,

Hardware usage is normal.

We have not seen anything suspicious at SQL monitoring as well.

Regards,

Hassan

Was this reply helpful? Yes No
Hassan_rulz 3,801 on at

Like (0)

Report

Hi Vijay,

I will check with my Dev team about this.

Regards,

Hassan

Was this reply helpful? Yes No