Results 1 to 4 of 4

Thread: Blocking Issue

  1. 11-17-2005, 08:58 AM #1
    olutimi
    olutimi is offline Registered User
    Join Date
    Jul 2003
    Posts
    142

    Exclamation Blocking Issue

    Please advice.

    I have a sql2K SP3 active/passive failover cluster running on W2K SP4. I epxerienced a blocking scenario. The blocking process was killed only to find another process cause blocking. Killing the blocking process didn't resolve the blocking issue.
    Eventually I had to fail over the SQL Server instance to another node and that brought resove the blocking issue.
    What direction should I look for investigation and solution.
    URGENT PLEASE.

    Help appreciated
    Reply With Quote Reply With Quote
  2. 11-17-2005, 09:17 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You should check what kind of process and query caused blocking. You can find blocking process spid with 'sp_who2 active' and find the query ran by the process with 'dbcc inputbuffer(spid)'.
    Reply With Quote Reply With Quote
  3. 11-17-2005, 10:27 AM #3
    olutimi
    olutimi is offline Registered User
    Join Date
    Jul 2003
    Posts
    142
    Thanks for the prompt reply.

    The developers collected the info while I was away. Any direction I could look into for a solution or cause of the blocking?


    Regards
    Reply With Quote Reply With Quote
  4. 11-17-2005, 12:48 PM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Usually caused by query that holds lock for long time, try add nolock hint if it's select statement. And keep transaction as short as possible.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules