Post reply

How to release a locked object

  • September 23, 2003 at 12:55 pm

    #65111

    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.

  • September 23, 2003 at 7:12 pm

    #475525

    Take a look at the links I posted in response to your other post,

    http://qa.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

  • September 24, 2003 at 8:04 am

    #475593

    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

  • September 24, 2003 at 4:22 pm

    #475687

    Is blocking the same as a dead lock? How long should I wait before killing the blocking process?

  • September 24, 2003 at 7:00 pm

    #475705

    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

  • September 25, 2003 at 12:26 pm

    #475859

    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.

  • September 25, 2003 at 5:06 pm

    #475895

    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