Post reply

SQL process Blocking problme

  • December 16, 2002 at 8:04 pm

    #64485

    Anyone can help me on this ...

    I notice that, SQL server process always have a blocking problem and caused the timeout error and system slow down. May I know how to avoid process blocking problem in SQL?

    Thanks in advance .

  • December 17, 2002 at 5:06 am

    #444583

    Review the process that are specifically causing the blocking. You have to determine what needs to be fixed. Could be adding indexes, rewriting queries, or maintainence on a db. But to fully understand your problem you will need to be more descriptive.

  • December 17, 2002 at 12:46 pm

    #444626

    To find out what causes blocking to the process with id 123, execute

    sp_who2 123

    You'll see BlkBy column with a dot (meaning no blocking) or a number indicating another process ID. That process is blocking your process 123. Use sp_lock to find out what tables are blocked by the given process. Optimize your queries and reduce transaction time to avoid locking and blocking.

  • December 17, 2002 at 5:53 pm

    #444653

    Thank for you reply.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply