mainrotor
asked on
How do I check or remove locks from SQL Server
Hi experts,
How do you check for, and remove locks in SQL Server 2008 R2?
Thanks in advance,
mrotor
How do you check for, and remove locks in SQL Server 2008 R2?
Thanks in advance,
mrotor
Hi
To unlock have a look at the below links
https://redmondmag.com/Articles/2011/01/01/SQL-Server-2008-R2-Unlock-the-Locks.aspx
http://www.exacthelp.com/2012/08/how-to-release-or-remove-lock-on-table.html
http://blog.sqlauthority.com/2008/08/18/sql-server-detailed-explanation-of-transaction-lock-lock-type-avoid-locks/
To unlock have a look at the below links
https://redmondmag.com/Articles/2011/01/01/SQL-Server-2008-R2-Unlock-the-Locks.aspx
http://www.exacthelp.com/2012/08/how-to-release-or-remove-lock-on-table.html
http://blog.sqlauthority.com/2008/08/18/sql-server-detailed-explanation-of-transaction-lock-lock-type-avoid-locks/
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Can you be more precise on what you want to do?
There are few ways to check and prevent locks.
What you mean with remove locks? Tuning the query to prevent future locks or kill the blocking process?
There are few ways to check and prevent locks.
What you mean with remove locks? Tuning the query to prevent future locks or kill the blocking process?
To check for lock you can look at the store procedures sp_who & sp_lock