4 replies
It is because processes are blocked by other processes acquiring locks which are needed for their query. You should run sp_who or sp_who2 and check the blocked column, if it is not zero it is the spid that is blocking that process. Be careful about killing processes just to speed up performance as these problems are most often caused by poor database design and you might be stopping crucial reports or queries from running. You should run SQL Trace to see what the blocking process is accessing. Also some processes have multiple connections, such as Enterprise Manager so you could make it unstable if you killed one of those,
Regards,
Andrew.
Further to my earlier note, I found an article which covers this in-depth, look at http://www.sql-server-performance.com/reducing_locks.asp (Tips for Reducing SQL Server Locks),
Regards,
Andrew.
by bkerkhoff
by bkerkhoff
This discussion is closed to new replies.
Trending Networks posts
Sort by Trending