none
What is the blocking and deadlock where to use? RRS feed

Answers

All replies

  • Generally speaking is a blocking consistent of 2 different Processes trying to alter a certain set of data, the first to come is the first who is allowed to change something, the other one has to wait until the first is finished.

    A Deadlock on the other hand is two stored procedures trying to change values which can end up in an infinite blocking or if mechanisms are in place to prevent this end up terminating the blocked (second) stored procedure's request. If you want to see which Process is blocking or being blocked, open the Activity Monitor and look for the columns is_blocking and is_blocked, Processes involved in a blocking with have a '1' as field value.

    Hope this helps, if not please provide further details on your question.

    Sunday, September 9, 2012 3:56 PM
  • Generally speaking is a blocking consistent of 2 different Processes trying to alter a certain set of data, the first to come is the first who is allowed to change something, the other one has to wait until the first is finished.

    A Deadlock on the other hand is two stored procedures trying to change values which can end up in an infinite blocking or if mechanisms are in place to prevent this end up terminating the blocked (second) stored procedure's request. If you want to see which Process is blocking or being blocked, open the Activity Monitor and look for the columns is_blocking and is_blocked, Processes involved in a blocking with have a '1' as field value.

    Hope this helps, if not please provide further details on your question.

    For defining blocking and deadlocking, I don't think this is completely accurate.  Please read the links below:

    http://support.microsoft.com/kb/224453 - blocking

    http://www.sql-server-performance.com/2006/deadlocks/ -deadlocks



    Thanks, Andrew

    Sunday, September 9, 2012 7:14 PM
  • Deadlocks Bible 

    http://blogs.msdn.com/bartd/archive/2006/09/09/747119.aspx
    http://blogs.msdn.com/bartd/archive/2006/09/25/770928.aspx


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Blog: Large scale of database and data cleansing
    MS SQL Consultants: Improves MS SQL Database Performance

    Monday, September 10, 2012 5:29 AM