Hi!

Self blocking is beacuse the process need to wait

for it own processes (paralel processes,

pages-i/o disk bottleneck) check out the

syslockinfo system table and the lastwaittype column.

-This link can be helpful...

Hi There...

Maybe this link can help, it does report the

locking activity on your sql, simple sp that

can be run as a schedule trace.

How to monitor blocking in SQL...