How to resolve the blocking issue | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to resolve the blocking issue

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..
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
Moderator All postings are provided “AS IS” with no warranties for accuracy.

See this…g-list-for-the-objects-indexes-using-dmv.aspx to get blocking list for more assessment and resoluiton. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.