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_lockcan 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
http://support.microsoft.com/kb/271509
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
See thishttp://sqlserver-qa.net/blogs/perft…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
http://www.SQL-Server-Performance.Com
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.
]]>