We are experiencing very slow performance every 3 days and have to turn off Management Reporter and restart. Everything is fine until day 3.
It appears to be from change tracking.
1. Is there something we should be doing with the log file after auto_cleanup start?
2. I noticed that changes are tracked for GL10000 and GL 10001. If we really only care about posted amounts for our reports, can we turn change tracking off for those tables. These tables have about 250,000 records in a change tracking table with auto cleanup set to 3 days.
3.Is tracking GL40000 necessary for Management Reporter, that has nearly 80,000 records in Change tracking in three days.
*This post is locked for comments