On Premiss Server Slowing Down - SQL Log files ?

Hello everyone,

Request to our server have been seriously slowed down this week. 

While checking the table's size, the report below has been displayed. 

Does any know what's the " tracker " table ? 

is the size of the table responsible for the trouble shoot ? 

Parents
  • Hi Thibaut,

    1. The purpose of the Tracker is explained here: https://support.sugarcrm.com/Knowledge_Base/Reports/Understanding_Tracker_Reports/index.html 

    2. The Tracker usage is configurable via Administration (navigate Administration -> Tracker)
    It looks like this:

    3. If Tracker is enabled, it can collect A LOT of data. For such case, there is out-of-the-box Job that does clear the table regularly

    I'd suggest checking whether Job is Active and actually run 

    If the Job is active and running regularly, the Tracker itself may contain important information useful for finding the performance bottle-neck and that is from what performance optimization starts.
    What performance optimization usually includes you can read here: SugarCRM Performance Tuning. Optimize Your CRM System | Integros 

    If you have any questions feel free to reach out to me dch@integroscrm.com 

    All the best,

    Dmytro Chupylka

    Best Regards,
    Dmytro Chupylka

    integroscrm.com
    We make work in Sugar CRM system faster, more convenient and efficient

  • Hello Dmytro, 

    Thank you for your advise. We've set up some trackers few months ago and the amount of data collected is huge. 

    there's a scheduler meant to delete the tracker file but it doesn't seems to be running ? 

    Can the accumulation of files be responsible of the CRM loss of speed ? 

    Regards 

  • Hi Thibaut,

    function::trimTracker is that job that should clear the Tracker tables from the data older specified in the Tracker configuration (the parameter is in Administration -> Tracker)

    However, "Job log" provided on your screen is empty an Last Successful Run is "Never", seems this Job haven't been working ever.... You could check whether other active jobs have any successful runs.
    If there are issues with them as well, try to check the "cron" on your server, maybe it is not configured properly preventing Jobs to run

    All the files uploaded are represented in db with referrals, so in case of many files, the poor or inappropriate indexing potentially may affect database data reading performance.
    But that is guessing, if you check the link to performance tuning suggested above, you will find a lot of potential reasons for performance downgrade and involving experts saves time and nerves.

    Prior to checking the cron and clearing the Tracker (clearing db and reindexing definitely may help), I'd suggest making a backup of the db just in case that clearing Tracker won't help and you decide to involve experts, because the Tracker may contain information that can speed up search for performance bottle-necks

    All the best, 

    Dmytro

    Best Regards,
    Dmytro Chupylka

    integroscrm.com
    We make work in Sugar CRM system faster, more convenient and efficient

Reply
  • Hi Thibaut,

    function::trimTracker is that job that should clear the Tracker tables from the data older specified in the Tracker configuration (the parameter is in Administration -> Tracker)

    However, "Job log" provided on your screen is empty an Last Successful Run is "Never", seems this Job haven't been working ever.... You could check whether other active jobs have any successful runs.
    If there are issues with them as well, try to check the "cron" on your server, maybe it is not configured properly preventing Jobs to run

    All the files uploaded are represented in db with referrals, so in case of many files, the poor or inappropriate indexing potentially may affect database data reading performance.
    But that is guessing, if you check the link to performance tuning suggested above, you will find a lot of potential reasons for performance downgrade and involving experts saves time and nerves.

    Prior to checking the cron and clearing the Tracker (clearing db and reindexing definitely may help), I'd suggest making a backup of the db just in case that clearing Tracker won't help and you decide to involve experts, because the Tracker may contain information that can speed up search for performance bottle-necks

    All the best, 

    Dmytro

    Best Regards,
    Dmytro Chupylka

    integroscrm.com
    We make work in Sugar CRM system faster, more convenient and efficient

Children
No Data