D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

archiving Dynamics AX

  • 1.  archiving Dynamics AX

    Posted 27 days ago
    ​​Anyone have any success using IDMF for archiving on AX 2012 (we are on R2)?  We are considering using it but want to know the downfalls before we get too far into it.  We have over 1TB of production data and growing and want to remove historical information for performance reasons and just shear size.

    ------------------------------
    Renee Schmitz
    Milwaukee Tool
    Brookfield
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: archiving Dynamics AX

    Posted 27 days ago
    Evaluated and discounted for now. Fast discs, good indexes, careful setup of SQL files to optimise restore, delete what you can, and monitor/fix poor queries. Our AX2012 environment is larger than that. Pre go live we created a load test environment with 3TB worth of transactions, and it coped fine.

    ------------------------------
    Andrew Russell
    direct wines
    Theale
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: archiving Dynamics AX

    Posted 26 days ago
    We've looked at it.  Honestly, it wasn't easy to learn to use and ultimately it became more of an issue of what to remove that would reclaim any meaningful space.  We have some regulatory issues due to being a transportation type company that require us to keep some data that others many not need to but we had better results in compression and as stated before, fast disks, indexes etc.  We also have the luxury of having a good DBA in house.

    The first time we looked at it was back on 4.0 and we couldn't get it to work.  There doesn't seem to be a lot of knowledge about it or at least we couldn't find any.  It will break down graphically where all your space is being consumed and all the interdependencies, but there never seemed like there was enough space to be safely gained to justify the effort of learning the tool or paying someone else (If you could find someone) to do it.  Michael DeVoe used to be the Microsoft expert but I think I remember hearing that he is no longer an option.

    If you don't bring your transactions forward during an upgrade, you could end up with an icon on everyone's desktop pointing to the old versions (4.0, 2009, 2012 etc.) or a monster size database.  Sure seems like it could cause people problems.

    I would be interested in hearing what people have done, but regarding the use of the IDMF tool to solve your problem, I can't recommend it.

    ------------------------------
    TJ Dennis
    CIO
    Wilson Trailer Company
    Sioux City IA
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role