Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in [path]/includes/class_bootstrap.php(430) : eval()'d code on line 110
What is blocking and how would you troubleshoot it?

Results 1 to 2 of 2

Thread: What is blocking and how would you troubleshoot it?

  1. #1
    Senior Member
    Join Date
    Jun 2015
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    What is blocking and how would you troubleshoot it?

    Blocking happens when one connection from an application holds a lock and a second connection requires a conflicting lock type. This forces the second connection to wait, blocked on the first.

    Read up the following topics in SQL Server books online: Understanding and avoiding blocking, Coding efficient transactions.

  2. #2
    Member
    Join Date
    Dec 2018
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts
    What is blocking and how would you troubleshoot it? Blocking occurs when a process has acquired lock on a set of rows, and another process is trying to acquire a lock on the same set of rows. ... - Problem is hinted by the WAIT status is a lot of rows that are returned as an output of sp_lock stored procedure execution.

Similar Threads

  1. What is blocking factors?
    By cbdmoversperth in forum Off Page / On Page SEO
    Replies: 6
    Last Post: 06-13-2016, 10:20 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •