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