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

Can you tell me about the concept of ER diagrams?

600


Do you know the cursor optimization tips?

589


how can u get last observation in an unknown dataset ?

2003


How to generate create table script on an existing table in ms sql server?

641


What is the use of toad or sqldbx.?

723






Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

501


How many triggers you can have on a table?

533


What are advantages of ssrs or why we should use ssrs?

104


What are the acid properties?

553


What are the different types of sub-queries?

600


What is the difference between count () and rowcount ()?

523


What is inner join in sql server joins?

545


Explain important index characteristics?

560


What is the use of for clause?

581


What are ddl (data definition language) statements for tables in ms sql server?

544