Our client has started experiencing lots of blocking, which is slowing down their system.
They only noticed this on Tuesday, it wasn’t an issue before that.
The blocking happens several times a minute, for just a few seconds each time.
It is experienced by many different users, in different areas of Navision, with no noticeable pattern.
In all cases, in the session table, the userID is the same as the “blocking user ID” (i.e. the user seems to be blocking their own ID), and the “blocking object” is blank.
So it is not clear what to investigate (and besides, no objects were modified in the last 12 days).
I sent the clie a document with several different suggestions (e.g. turning off “Find As You Type”, ensuring that there is sufficient free space, running SQL maintenance jobs regularly, turning off AutoCostPosting, etc.). They said that they implemented many of the suggestions without seeing any improvement.
ChangeLog is only activated on two tables, which are part of an add-on.
They are using Nav 3.70 B on SQL 2000, with a 60 GB database.
How can we find what is causing the blocking, when there is no blocking object (and no other user ID) mentioned?