Locking Error

sprashanth

Hi Everyone,

We are running on NAV 2009 and users work from near about 9 locations. We have a customization(Load IN/OUT) which practically posts a transfer order and sales invoice in the backend. any time of the day there will be 70 users working on the system and atleast 30 users always posts the (LOAD IN/OUT) transactions. It works very smooth but now and then we see the Locking error in the system. ](*,) (The abc table is locked by another user.......). Please share me your ideas on how to over come this issue and what are all the possibilities of this occurence.

Thanks and Regards.

kriki

First question:native of SQL DB?

sprashanth

Hi Kriki...

Here are few specifications.

Database : SQL (2008)
RAM : 18GB
HD : 700GB

kriki

-Classic or RTC?

A few things you can do:
-Make sure your transactions are as fast as possible. So have a good maintenance plan for your DB (rebuilding indexes).
-Make sure you don't have RAID5 (especially for the transactionlog file).
-Dedicate a disk (RAID1) for the transactionlog. Nothing else may be on that disk
-You have a lot of memory, so you can use "Rowlocks"=Yes (File=>Database=>Alter=> Tab Advanced). You can also increase the Lock timeout duration from the standard 10 seconds to 30 seconds (or even more).
-Your users must work on fast computers because it are the client-computers that do all the processing.
-Make sure your network is fast enough.
-You can do some index/SIFT tuning so the writing is faster.


Something you can't do a lot about it:
-If you have 10 users that post at the same second, they posting will be handled serially by NAV. So the only thing you can do about this is speed up the process as much as possible.

sprashanth

yeah we are on Classic also we have a dedicated disk for transaction log file(RAID1). Few points in your post are being implemented here and I will also try rest of the points are covered and then lets hope for the best.

Thanks for the valuable points.

.