How to release a locked object
-
From the EM/Management/Current Activity/"Locks / Object", there are a few objects are locked. If I want to release them from the lock, how can I do it?
Your quick response is appreciated.
-
Take a look at the links I posted in response to your other post,
http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=16581&FORUM_ID=9&CAT_ID=1
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
--------------------
Colt 45 - the original point and click interface
-
The process running may need a lock to complete the transaction. If you are experience the deadlock or blocking you need to change the coding part of the program or schedule the programs in an order so that you don’t see the blocking. The only way to Offset the locking is to kill the transaction, which you don’t want to.
Shas3
-
Is blocking the same as a dead lock? How long should I wait before killing the blocking process?
-
Very basically a deadlock occurs between two threads when each thread requires a resource that the other thread owns. Therefore both threads are effectively waiting on each other. Blocking is where one or more threads are waiting on a resource that another thread currently owns. A simple example of this is when a transaction is started but not committed.
There is a good explaination of deadlocks in Books Online, check the topic titled "Deadlocking".
Blocking is a different matter. Check "Understanding and Avoiding Blocking" in Books Online.
As for how long you should wait to Kill the blocking process, well it depends on why the blocking is occurring. If it's a critical data update that has to complete, you probably want to wait for it to finish. If someone is running a badly structured query that is consuming resources, you probably want to Kill it as soon as you determine that's the problem.
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
--------------------
Colt 45 - the original point and click interface -
In my case, the thread is holding one transaction but the status is waiting and it has been waiting for hours which blocked other transactions.
-
Have you tried any of the techniques described in books online to determine why the blocking is occuring?
Also, take a look at the following articles, they contain some handy tools,
http://support.microsoft.com/default.aspx?scid=kb;en-us;295108&Product=sql2k
http://support.microsoft.com/default.aspx?scid=kb;en-us;271509&Product=sql2k
http://support.microsoft.com/default.aspx?scid=kb;en-us;283725&Product=sql2k
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
--------------------
Colt 45 - the original point and click interface
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply