Last post Jan 16, 2018 03:40 PM by wmec
Jan 12, 2018 06:49 AM|saffy|LINK
What can be the possible reasons Locking happening in one table while insert and update.
Initially it was working normal. suddenly started locking.
No new index created, Table size normal as before, fragmentation normal.....
Jan 12, 2018 10:54 AM|oned_gk|LINK
Try find it in event viewer administratin tools
Jan 16, 2018 01:42 AM|Deepak Panchal|LINK
Did you try to check whether there is any 'commit' or 'rollback' is pending or not.
Try to commit and check whether it removes the lock from the table or not.
SQL locks the table sometimes, if commit or rollback are pending.
So you can try to check it and let us know about your testing result.
So that we can try to provide you further suggestions, if needed.
Jan 16, 2018 03:40 PM|wmec|LINK
Where ID is relevant SPID you want to kill/remove