sudhakara (1/22/2011)

---

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.