How can your resolve deadlocks?

Answer Posted / sasikala

one way to kill the process which is responsible for dead lock. after this the process can proceed without any problem. after a process completed , the killed process should be created and executed as if nothing has happened. but the killed process might have changed in an data base or some records. it must have changed as before to maintain the consistency.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many categories of functions based their return modes?

598


What is sub-query in sql server?

676


What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

602


What is the usage of the sign function?

538


What is indexed view? How to create it?

603






What is difference between getdate and sysdatetime in sql server 2008?

606


What are key, name and value columns of an attribute? : sql server analysis services, ssas

580


What are the different types of stored procedures?

558


Tell about MOM Tool(Microsoft Operator Manager)?

1418


Explain system rowset functions?

568


How is foreign key related to primary key?

578


What is row_number () and partition by in sql server?

526


What is dimension table? : sql server analysis services, ssas

565


What is resource db in sql server?

603


What is global temp table?

569