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

couberpu

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

Alex_Chow

Check what Windows Updates were installed and remove as necessary.

kine

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.

couberpu

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,
CouberPu