Batch Job execution too late

(0) Share

Report

Posted on by veera seenivasan

575

Hi Experts,

I am running a batch job in AX 2012 which is taking very long time to complete.There is no lock in database and no issue in code too and batch server is using four AOS server. Can anyone suggest me some good idea to find that.

Thanks&Regards

Michael

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

Mea_ 60,284 on at

Like (0)

Report

Hi Michael Adam,

We are not aware what this batch job is actually doing, so it's probably impossible to say what to improve.

Anyway you have tools like trace parser blogs.msdn.microsoft.com/.../walk-through-major-features-of-microsoft-dynamics-ax-2012-trace-parser-part-1 that could tell you exactly what is happening, what operations are heaviest so you will be able to identify bottleneck and and address them. Or at least provide additional details to us and we will be able to give you some help.

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

You should measure what takes all the time. Tracing / Trace Parser is usually a good starting point.

Was this reply helpful? Yes No
Vilmos Kintera 46,149 on at

Like (0)

Report

If your batch job is single threaded (only have 1 batch task), it does not matter how many batch AOS instances you have, will only execute on 1. Without explaining your situation better, we will not be able to assist you with better recommendations other than what you already got: Trace your code server-side, then check if code execution due to bad design, or SQL statements due to too complex joins, bad indexing, or lack of resources (CPU/RAM/disk io bottleneck) is the reason for taking it too much time.

Was this reply helpful? Yes No
veera seenivasan 575 on at

Like (0)

Report

Hi ievgen,

The batch job is created using Sysoperation framework.In sysoperation service controller class the main method is commented so it might me a reason for long execution?

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

Hey Michael Adam,

You have 3 persons saying the same - do a trace, see what takes so long. It doesn't really matter if it's a runbasebatch or Sysoperation you can have "bad" code anywhere.

If you really want to get help you need to give us a much details as you have and describing some bits of pieces of your code is not a best way to go.

Was this reply helpful? Yes No
veera seenivasan 575 on at

Like (0)

Report

Hi ievgen

Thanks for your reply .I have figured out the class method which is taking longtime.

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

Hey Michael Adam,

If you will share some details maybe it would be helpful for someone with similar issue.

Was this reply helpful? Yes No