July 11, 2010 at 11:44 pm
Wanna know what Deadlock is?
From To Message
Boss Secretary For a week we will go abroad, so make arrangement.
Secretary Husband For a week my boss and I will be going abroad, you look after yourself.
Husband Secret lover My wife is going abroad for a week, so let’s spend the week together.
Secret lover Small boy (whom she is giving private tuition) I have work for a week, so you need not come for class.
Small boy Grand-father Grandpa, for a week I don't have class 'coz my teacher is busy. Let’s spend the week together.
Grandpa ( T he B oss 🙂 ) Secretary This week I am spending my time with my grandson. We cannot attend that meeting.
Secretary Husband This week my boss has some work, we cancelled our trip.
Husband Secret lover We cannot spend this week together; my wife has cancelled her trip.
Secret lover Small boy This week we will have class as usual.
Small boy Grandfather Grandpa, my teacher said this week I have to attend class. Sorry I can't give you company.
Grandfather Secretary Don't worry this week we will attend that meeting, so make arrangement.
So one process waiting for another 🙂
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
July 11, 2010 at 11:49 pm
suresh kumar Sulakh (7/11/2010)
So one process waiting for another 🙂
No, that's blocking. Deadlock is two processes waiting for each other in such a way that neither will ever complete if left alone. If you want an anecdote, go look up the hungry philosopher problem.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 12, 2010 at 3:55 am
July 12, 2010 at 3:58 am
I actually searched it once Gila mentioned it and went through it 🙂
A long reading nicely put.
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
August 5, 2010 at 7:28 am
Deadlock is situation .when one user process conflict with another user process to consume the objects
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply