Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Benjamin Myers 2 posts 82 karma points
    Mar 15, 2019 @ 18:14
    Benjamin Myers
    0

    We are using Umbraco 7.4.2 and have it in 4 environments. In our test and staging environments the URL Tracker tab loads completely fine but in QA and Production the window comes up and a spinner just sits there and never loads.

    Has anyone else seen this behavior?

    How can I fix this?

  • Marc Goodson 841 posts 5469 karma points MVP 3x c-trib
    Mar 16, 2019 @ 11:25
    Marc Goodson
    101

    Hi Benjamin

    Have a look in the icUrlTracker database table on production... how many rows have you got?

    if you have UrlTracker setup to track every 404 requests to the site, this can build up over time, in the order of millions, and then the backoffice dashboard times out over the connection string trying to read them.

    You can turn off this functionality in the config

    <add key="urlTracker:404UrlsToIgnore" value="wp-login.php" />
    <add key="urlTracker:notFoundTrackingDisabled" value="true" />
    

    and delete any existing 404 tracked entries if you are not actually making use of them, you can use iis logs if you have interest in which pages 404, or run a Xenu link checker etc to hunt for 404s

    If this is the case, and you do end up deleting millions of rows in the table, it will be worth checking for any fragmented indexes in the db table: https://docs.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-2017

    regards

    Marc

  • Benjamin Myers 2 posts 82 karma points
    Mar 24, 2019 @ 15:43
    Benjamin Myers
    0

    Thanks, Marc! This worked like a charm!

Please Sign in or register to post replies

Write your reply to:

Draft