IÂ´ve attached a file with the procedure and trigger to insert a record in a
The table is accesed for almost 300 users. Several times at day the table is
locked and I have to kill the process which has exclusive lock on it.
Sometimes I have to kill 2 or 5 times more to release the problem. IÂ´ve
tried partioning the table before. This day i set row locking on it, but the
problem remains. I run sp_object_stats and it reports contention above 75%
in some periods of time. It could be better to drop the trigger?,
Development System says it is not necessary in our case.