Slow - Server or NAV

ajayjain

Hi,

This is quite common Navision gets blame if it is slow.
I have identified many times the whole system is slow, even if you do something outside NAV.

Is there any tool which communicate with server and check if server reply is slow like Ping
also how can i check what is running on server in the background other than task list and services

Thanks
Ajay

David_Singleton

Step one is to define "slow".

ajayjain

NAV works fine for a week
and suddenly hanging and getting locking issues for more than 30 people
every process taking minutes which used to take seconds
we are version 4.03 sql with 250 users

Thanks

David_Singleton

You really need to define it. What is slow? How long did it take before how long now? You need to define exactly what is slow, saying "Navision is slow" really means nothing. Like saying "it takes me ages to get to work where last week it was really fast". Do you drive to work or catch a bus or metro or rid a bike? Are there road works. Is the metro closed and you had to take a bus? Did your bike break and now you are walking. Did your kids just start school and are you now having to drive to the other side of town to take them before going to work. Did your alarm clock break and you are getting out of bed late. Did you change jobs and now where you used to bike you now need to drive across town.

davmac1

Have you tried resource manager and perfmon?
Have you tried running a SQL Profiler trace for long running queries?
Are you running users through a terminal server that is experiencing memory constraints? That will kill performance for sure is use NAV sessions are swapping.
Any new PCs introduced - check their performance.

How long has your system been running? If not for long, then configuration problems can start causing problems when the database has grown.