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 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.
