NAV 3.6 with 3.70b run time running on SQL 2000 enterprise

couberpu
Member Posts: 317
Good Morning,
Just want to ask if anyone had similar issue:
We are running NAV 3.6 with 3.70b run time on SQL 2000 enterprise. The size of the database is about 92GB, with 30GB log file, RAID 10. It was not super fast but steady as it goes until yesterday morning. Users in the system now experiencing slow down and delay issues all over the place. It was random and there was no error message in event log. The database seems running fine and server performance check out fine. Just a lot of i/o delays.(but not all the time, users are having ups and downs performance)
I can not real do anything until later tonigh but need some advise on areas I should start checking to fix this performance issue.
Thanks,
CouberPu
Just want to ask if anyone had similar issue:
We are running NAV 3.6 with 3.70b run time on SQL 2000 enterprise. The size of the database is about 92GB, with 30GB log file, RAID 10. It was not super fast but steady as it goes until yesterday morning. Users in the system now experiencing slow down and delay issues all over the place. It was random and there was no error message in event log. The database seems running fine and server performance check out fine. Just a lot of i/o delays.(but not all the time, users are having ups and downs performance)
I can not real do anything until later tonigh but need some advise on areas I should start checking to fix this performance issue.
Thanks,
CouberPu
0
Answers
-
Check what Windows Updates were installed and remove as necessary.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
Or check that the HDDs are in good condition. Or may be some restart of the system - it could lead to empty caches and it can take some time to "heat up" the system.0
-
Good Morning,
Thank you all.
I just found a supper hot switch in the system and replaced it. Did a quick cost update run and it ran much much faster than last night. Not sure if the switch is the cause. Have to run more test and find out Monday when users signed in.
Thanks,
CouberPu0
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