InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 12:58:44 GMT20http://www.sqlservercentral.com/Forums/Topic1052004-146-1.aspx[quote][b]sudhakara (1/22/2011)[/b][hr]Hi,Am Getting alert message from third party monitoring tool saying that blocked process reaches 99% on the ms sql server 2005. but there is no blocking on the server and found there too many sessions (>200) on the suspended status with awaiting command mode. Only few shared locks are there for each session. Can any one tell me how to find the blocking process percentage and give me link where i can find more about that ?Thanks in Advance.[/quote]1) why is 200 spids waiting for commands "too many"?2) blocked process percentage is pretty useless as a metric IMHO. use sp_whoisactive to find live blocking and start fixing the causes.Mon, 24 Jan 2011 07:08:47 GMTTheSQLGuruhttp://www.sqlservercentral.com/Forums/Topic1052004-146-1.aspxYou can make use of [i]sys.dm_tran_locks[/i] DMV to get that information. [b][url=http://weblogs.sqlteam.com/mladenp/archive/2008/04/29/SQL-Server-2005-Get-full-information-about-transaction-locks.aspx]Here[/url][/b] is an example.Sun, 23 Jan 2011 10:28:20 GMTAdigahttp://www.sqlservercentral.com/Forums/Topic1052004-146-1.aspx[quote][b]Adiga (1/22/2011)[/b][hr]I am not sure how the monitoring tool that you are using the Blocking Process %. You may query sysprocesses, sys.dm_exec_requests to find more information about the blocking processes. [b][url=http://support.microsoft.com/kb/224453]This article[/url][/b] is also a good read.[/quote]Thanks for your reply.My guess is it showing the lock manager occupied percentage. Could you share the document or guide me how to view the lock manager process on sql server 2005 ?Sun, 23 Jan 2011 10:19:16 GMTsudhakarahttp://www.sqlservercentral.com/Forums/Topic1052004-146-1.aspxI am not sure how the monitoring tool that you are using the Blocking Process %. You may query sysprocesses, sys.dm_exec_requests to find more information about the blocking processes. [b][url=http://support.microsoft.com/kb/224453]This article[/url][/b] is also a good read.Sat, 22 Jan 2011 22:18:47 GMTAdigahttp://www.sqlservercentral.com/Forums/Topic1052004-146-1.aspxHi,Am Getting alert message from third party monitoring tool saying that blocked process reaches 99% on the ms sql server 2005. but there is no blocking on the server and found there too many sessions (>200) on the suspended status with awaiting command mode. Only few shared locks are there for each session. Can any one tell me how to find the blocking process percentage and give me link where i can find more about that ?Thanks in Advance.Sat, 22 Jan 2011 16:54:17 GMTsudhakara