SQL Server Performance

How to resolve the blocking issue

Discussion in 'Getting Started' started by neo_143, Jun 29, 2007.

  1. neo_143 New Member

    in my company we use foglight so this is the alert

    SQL Server: DBSW348: SQLMaxBlockTimeMS:Critical: A process has been blocked for more than 300000 (ms)

    so whats the solution to resolve it. i am so confuse.. i used sp_who, sp_lock
    can anhyone tell ,me the procedure to do it. thnaks in advance.

    my senior dba asked me what cpu time it was consuming , what comand....
    like what to look for and what to do with it..
  2. MohammedU New Member

    First figure it out who is blocking what then you can resolve...

    Take a look to the following article...

    How to monitor blocking in SQL Server 2005 and in SQL Server 2000
    http://support.microsoft.com/kb/271509


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. satya Moderator

Share This Page