Possible Deadlock Condition

30 pts.
Tags:
Database
Possible Deadlock Condition
SQL Server 2005
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
ASKED: December 13, 2007  6:04 PM
UPDATED: December 14, 2007  2:39 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • ZiPPy
    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.
    30 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following