nav application slow down problem

qqtofu
Member Posts: 49
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
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
0
Comments
-
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?0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions