Discussion Locked

SP_IDS in SQL 7.0

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
MY server (NT) seems to slowing down, if i run an SQL query check (SP_LOCK) it show me duplicate ID's. If i clear the duplicate ID's this then speeds things up to normal. How can i stop this from happening ?

4 replies

by andrew prosser

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.

This discussion is closed to new replies.