AREV 3.12 - NLM STARTS FAST BECOMES SLOW (Networking Products)
At 05 DEC 2003 01:43:53PM Ted Archibald wrote:
A client has AREV 3.12 and NLM.
After a fresh NOVELL 4 start the system is very fast. Report A runs in 1/2 hour.
After 2 weeks of NOVELL up, the same report takes over 4 hours.
It seems like NOVELL or the NLM has become plugged up.
Does anyone have similar problems?
Does anyone have an idea what is going on here?
No major change to either NOVELL or AREV or NLM for 18months.
This problem seems to be getting worse over the last 6 months.
TIA
Ted
At 05 DEC 2003 01:45PM The Sprezzatura Group wrote:
Can you check NLM_STATS for any peculiarities?
The Sprezzatura Group
World Leaders in all things RevSoft
At 05 DEC 2003 01:53PM Ted Archibald wrote:
That was fast.
What type of "peculiarities" might I be looking for?
Ted
At 05 DEC 2003 02:14PM The Sprezzatura Group wrote:
Lots of aborted sessions, failure statistics etc. Don't have an NLM to hand so can't describe . Also does restarting ALWAYS speed it back up again?
The Sprezzatura Group
World Leaders in all things RevSoft
At 06 DEC 2003 12:54AM Ted Archibald wrote:
Tks
I will implement a better tracking system and will implement a stress test of the report in question to see how it handles over a week or so to see if I can track the problem. Also will review the NLM STATS. I will report back to this msg when complete.
Tks again
Ted
At 07 DEC 2003 06:27PM Steve Smith wrote:
Have you disabled TTS on the *.lk and *.ov files? TTS is a file attribute in Netware 4.x - FLAG.EXE (a Novell utility) can unset it - but it is enabled by default in a standard 4.11 install (from my rusty memory). It would explain the behaviour you describe - gradual degradation of performance.
Also check your monitor.nlm on the server for any adverse stats - such as CRC failures.
Also check you aren't virus scanning the OV files.
Also clear out your LISTS table periodically and resize (Ctrl-R Ctrl-C from DUMP). Only do this if the application doesn't need saved LISTS or data in the LISTS file. A bloated lists table (or one with lots of "air" inside) will grow and degrade.
Also check the DELETED.SAV path on the SYS volume - once this fills up with older temp files - and this will depend on whether your application is heavy handed with OSDELETES / file deletions or selects (V119 - AREV table selection - creates temp files in some cases) then performance can degrade owing to excessive deletion activity.
Steve