Possible Deadlock Condition
I have a server at work that I have been having some serious issues with. It is our main server that holds our database and runs our applications.
For the last 3 days we have been receiving 'Possible Deadlock Condition' errors which leads to the server locking up. The only way to restart the server is to hard reset it.
We are running Microsoft SQL Server 2005 on the server.
What exactly does this error message mean and what can be done about it?
Thanks,
ZiPPy
Software/Hardware used:
Software/Hardware used:
ASKED:
December 13, 2007 6:04 PM
UPDATED:
December 14, 2007 2:39 AM
Answer Wiki:
A deadlock is when two processes are locking each other out and you end up with a circular lock situation. The basic idea is this.
Session 1 locks a record.
Session 2 accesses another record (could be the same table or a different table).
Session 2 tries to access the record that session 1 has locked but has to wait as session 1 still has a lock.
Session 1 tries to access to record that session 2 has locked but has to wait because session 2 has a lock on the record. We now have a deadlock because neither session will ever complete. SQL will kill one of the sessions and it back allowing the other session to complete.
You need to look into your code and see if you can clear up the problem.
To see all answers submitted to the Answer Wiki: View Answer History.
I also would like to add that the explorer bar is missing also when the server is having issues. I log into the server and the explorer bar is gone. I attempt to start it by adding new task being explorer.exe but that locks the server completely.