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


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

Share This Page