NAV 5.0 SP1 - SQL Server - Changing Companies Very Slow for only One User

dshaner
dshaner Member Posts: 2
in NAV/Navision Classic Client
We are using NAV 5.0 SP1 with SQL Server. Have one user, using windows login credentials, that takes at times 15 - 20 secs or more to switch companies. Replaced the machine which is directly on our network with no change. Even if the user logs in through a Terminal Server session, it still takes about the same amount of time. Other users including me switch in 1 or 2 secs. Checked SQL Server setup for the user's windows login and can't find anything different. Anybody have any ideas or similar issue?

Thanks,
StillonNAV5

Comments

  • Juhl
    Juhl Member Posts: 724
    Things to try.
    Removing the users zup file.
    Give super permission.
    Check with sql profiler, to see what's going on.
    Follow me on my blog juhl.blog
  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    Check if this particular user has enabled time registration. Check the User Time Register table, and eventually reduce the number of records in it by purging some old entries.

    Slawek
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03

Categories