Locking in one table while insert and update RSS

• • Reply
  saffy

  Member

  155 Points

  505 Posts

  Locking in one table while insert and update

  Jan 12, 2018 06:49 AM|saffy|LINK

  Hello all,

  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.....

  Still locking...

  Any suggestions.

  Short URL -
  Shorten Your Long URL to Short URL - https://smar.in
• • Reply
  oned_gk

  All-Star

  51301 Points

  15131 Posts

  Re: Locking in one table while insert and update

  Jan 12, 2018 10:54 AM|oned_gk|LINK

  Try find it in event viewer administratin tools

  Programming to simplify, don't look for difficult way
  Suwandi - Non Graduate Programmer
• • Reply
  Deepak Panch...

  Contributor

  2550 Points

  1056 Posts

  Re: Locking in one table while insert and update

  Jan 16, 2018 01:42 AM|Deepak Panchal|LINK

  Hi saffy,

  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.

  Regards

  Deepak

  MSDN Community Support
  Please remember to click "Mark as Answer" the responses that resolved your issue.
  If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
• • Reply
  wmec

  Contributor

  6353 Points

  5568 Posts

  Re: Locking in one table while insert and update

  Jan 16, 2018 03:40 PM|wmec|LINK

  1. Run

  SP_LOCK

  2. Run

  Kill ID

  Where ID is relevant SPID you want to kill/remove

  Many Thanks & Best Regards,
  HuaMin Chen