Hello friendzzz, i know that when a cycle occurs in more then three processes ,then this state is called deadlock. How i can release that problem.. And also tell me for deadlock condition a cycle is necessary or not.....

Is it the OS or any application that is in dead lock state??Raj

Is this SQL Server deadlock? If so I'd ask them here.http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/threadsRegards, Dave Patrick .... Microsoft Certified Professional Microsoft MVP [Windows]

Hi dkapoor, thank you for posting in windows forums, when you said "a cycle occurs in more then three processes " i have the following questionsa) is this you want to learn / understand b) Is this a problem in your environment ? and you want to troubleshoot it ?Your question is a broader one , though you might get many different answers in web / books or other sources, you need to understand the following process architecture --> virtual address and virtual memory --> user mode and kernel modeAnd a deadlock with respect to process is different from a deadlock occuring in CPU. with respect to process its always / most of the time user mode process waiting for the resources in a circular manner or mutual exclusion. in other words two process in different address space wait for a resource to get released and none of them accomplish the task, they go in a deadlock state either making the communication channel busy or break. secondly deadlock withrespect to CPU is that a memory reference is made to a memory location which never / doesnt exists and handling this sitauation is totaly depend on the memory controller. If your memory controller is programmed in a way to handle this situation then you dont see a deadlock In the above CPU deadlock situation, the only option is to restart the system. But today's architecture has the mechanism to resolve these issues. sainath !analyze