AX2009->AX2012 R2 upgrade performance

This question is not answered

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

All Replies
  • 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.

    kind regards,

    André Arnaud de Calavon  |  Microsoft Dynamics AX Solution architect  |  My blog  |  My company

    This post is my own opinion and does not necessarily reflect the opinion or view of my company, Microsoft, both its employees, or other MVPs.

  • 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

  • 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

  • 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

  • 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

  • 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. 

  • 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 ..

  • 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