Open Forum

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

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


Original Message------

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

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

Original Message:
Sent: 12-05-2018 06:18 PM
From: Kerry Hataley
Subject: Check Links Long Duration Recommendations

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


Original Message------

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