Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Unanswered

AX2009->AX2012 R2 upgrade performance

Posted on by 2,721

Hi we are right in the middel on testing / planing an upgrad from AX 3.0 (yes) via 2009 to 2012 R2..

Most of the Jobs in the AX 2012 data upgrade Center run fine and relativly fast .. except  thos:

Split billing lines updateCostSalesLineFunders Proj 3198.35 min

Update PSAProjProposalProj table updatePSAProjProposalProjMajor Proj 4000 min

Did any one else have performace probs with both or one of them?

When looing at AOS and SQL both seem to be  bored .. AOS somewhto 5-10% CPU, still mem free. DB Server 3 % CPU. mem ok, haveing about 1300 Batch requests per second. Not seeing any lock or heavy disk traffice..

any ideas welcome

Pirmin

  • CU14050944-0 Profile Picture
    CU14050944-0 2,721 on at
    RE: AX2009->AX2012 R2 upgrade performance

    Hi

    as mentioned above we did split the whole job und thousands ( yes) of single jobs. And did run them on parallel.. then it took a day or so .. and the server was nearly on fire ;)

    Pirmin

  • Steven Harvey Profile Picture
    Steven Harvey 20 on at
    RE: AX2009->AX2012 R2 upgrade performance

    Hi Pirmin

    Did you ever find a solution to this long running job ? I know there is a hot fix from Microsoft for this, however i'm finding it still runs for a long time.

    How did you get past this?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AX2009->AX2012 R2 upgrade performance

    Hi Pirmin,

    we are upgrading from AX4 to AX2012R2 CU7.

    Batch job "updateCostSalesLineFunders" is running for days and we do not have a clue why...

    Would like to check back with you if there are any news you can share!

    Thanks!

    Toni

  • CU14050944-0 Profile Picture
    CU14050944-0 2,721 on at
    RE: AX2009->AX2012 R2 upgrade performance

    Hi

    well this one is still converting (since Sep 10th) .. i let it run just ..

    We did split up for the next test in multiple batchjobs.. will run it tonight ..

  • Nick Hulbert Profile Picture
    Nick Hulbert 195 on at
    RE: AX2009->AX2012 R2 upgrade performance

    Just wondering if anyone has worked out how to speed this up?  I stopped the upgrade process after waiting 2 days for this to finish.

    Even then PSAProjProposalProj table had no records inserted.

    I'm upgrading from RTM to R2 btw - not from 2009. 

  • CU14050944-0 Profile Picture
    CU14050944-0 2,721 on at
    RE: AX2009->AX2012 R2 upgrade performance

    thanx.. well we have data of 13 (!!!!) years to Transfer!

    And currently the Job has created ~1.2 mio (!!) records in PSAProjProposal...

    good luck

    Pirmin

  • Chris Dando Profile Picture
    Chris Dando 10 on at
    RE: AX2009->AX2012 R2 upgrade performance

    10 days!

    I laughed at that, but actually it's not funny when you consider the system is unavailable to users when this job runs

    We've only started to think of a solution but if we have any success I'll let you know (I think the problem lies with the row-by-row processing which uses the ProjTrans wrapper classes)

    It's comforting to know we're not the only ones with this problem!

    Cheers, Chris

  • CU14050944-0 Profile Picture
    CU14050944-0 2,721 on at
    RE: AX2009->AX2012 R2 upgrade performance

    Hi Chris,

    sorry to say.. nope .. is still converting !  (since Sep. 10th) ..

    I don't dare so far to cancel the Job, as it is still creating some new records.  When i look at AOS Server, it seems to do something ( ~ 7 % cpu) the DB Server is more than bored (no siginficant  CPU, not Storage Action)  just ~ 1500 Batch requests per sec.

    We just started a perdormanc Analysis.. (with our developers)

    maybe paralell could be a solution as it not seems to use many ressources .

    Any other ideas?

    Pirmin

  • Chris Dando Profile Picture
    Chris Dando 10 on at
    RE: AX2009->AX2012 R2 upgrade performance

    Hi Pirmin,

    Did you make any progress with this issue?

    We are having the same problem with the updatePSAProjProposalProjMajor job taking many days to complete.

    I am considering splitting the job into multiple batch tasks each processing a subset of the ProjProposalJour records (and then run the jobs in parallel). Do you have any thoughts on this approach?

    Thanks, Chris

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 283,632 Super User on at
    RE: AX2009->AX2012 R2 upgrade performance

    Hi Pirmin,

    I have not seen an upgrade with Projects. Until now only (re)new implementations. The reason why I anwer on this topic is that I have seen a strange performance issue due to some checks in the project postings when you have multiple funding sources per project.

    You issue sound like this same experience I had before.

    You can check if the upgrade results in  lager number of funding sources in stead of one or some. I don't know your current setup. In many scenario's there will be just one funding source.

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,632 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,528 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans