nav application slow down problem

qqtofuqqtofu Member Posts: 49
edited 2007-09-21 in SQL Performance
Hi

wondering has anyone experienced the navision application slow down all of a sudden from some users within the same network trying to read/calculate from large data pool and the the whole thing just hang for everyone else in the network, and rebooting server seems like the solution?

this problem came up for us when some user is trying to read/write some data within the nav database, and is usually large data pool, but the user has done this for many years now. This problem just happen out of nowhere after many year with it working fine. It also random too, it never happen within the same process or day and time, and we were wondering if anyone have experience this issue and if a suggestion for a look out/prevention when this problem happen or even some type of solution if possible.



thank you

Comments

  • kinekine Member Posts: 12,562
    1) Update MDAC to newest one on all machines
    2) Check HW bottlenecks on the MS SQL server (RAM, HDD, CPU)
    3) Which NAV version?
    4) HW Config?
    5) DB Size?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.