Open Forum

Expand all | Collapse all

Check Links Long Duration Recommendations

  • 1.  Check Links Long Duration Recommendations

    SILVER CONTRIBUTOR
    Posted Dec 05, 2018 05:39 PM
    Hi, all. I'm trying to get through Check Links & Reconcile for the first time in our environment and I'm running into issues with the time it takes for certain series to complete. For instance, In our lab environment, I was running CL for Purchasing History and it ran well over 40 hours. I've used CDA to archive as much data as the Finance team will allow and I've done index and stats maintenance.

    I was wondering if anyone had recommendations to speed up CL & Reconcile and, I'd love to hear how you may have encouraged your company to allow enough downtime to complete the processes.

    Thanks.

    ------------------------------
    Jon Godwin
    Database Administrator
    Boulder CO
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Check Links Long Duration Recommendations

    GOLD CONTRIBUTOR
    Posted Dec 05, 2018 06:19 PM
    I need some info to put this into context...
    1. How many historical trx do you have
    2. How big is your company did
    3. What is the SQL server specs - memory, cpu, drive types (hdd or ssd)
    4. Have you removed history of the detail transactions

    Kerry Hataley
    Nanook Software


    Conference-GPUG_200x200


  • 3.  RE: Check Links Long Duration Recommendations

    SILVER CONTRIBUTOR
    Posted Dec 06, 2018 11:48 AM
    Sorry for not providing enough info before...
    • We have 13,675,000 historical transactions
    • Company DB is Data File is 290 GB with 101 GB Free thanks to CDA
    • SQL Server Specs
      • Virtual Machine
      • 4 CPUs 3.00GHz Each
      • 125 GB RAM
      • Data Drives are HDD / TempDB is SSD
    • We have removed completed PO's & Paid Transaction Removal up to 12/31/2017, which is what our Finance department dictated.

    Thanks again for any help.

    ------------------------------
    Jon Godwin
    Database Administrator
    Boulder CO
    ------------------------------

    Conference-GPUG_200x200


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