srinath.vanama (8/16/2011)
Hello Folks,am in similar kind of situation, on one of my Production server there are so many lockings are there it is causing performance problem.
1)I run a query sp_who4 active it results in same query with same login but different SPID's are showing in command text column.
2) SPID is blocking by same SPID is more than once.
i.e., ex: SPID:98 is BLKBy 98.
3) I run a SQL profiler and please guide me what to do next and how to fix this issue ASAP.
Srinath... This is a year old thread...
See when you're seeing a spid blocking itself then this is not a blocking issue this is a common scenario in multiple core systems....
Can you confirm you SQL Server edition and sp level.