Interested to Buy Any Domain ? << Click Here >> for more details...
What is deadlock and how to avoid the deadlocks.
- 3 Answers
- 10959 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / dba
P1 has lock on R1
P2 has lock on R2
P1 requests lock on R2
P2 Requests lock on R1
Where P & R are corresponding processes and resources.
Deadlock consists of two processes requesting locks on
resources thus, blocking each other.
You can avoid Deadlocks:
Access objects in the same order
Use lower isolation levels
Keep Transactions short and in one batch
Avoid user interactions in transaction
Use bound connections
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Is sql server 2016 free?
What type of locking occurs during the snapshot generation? : sql server replication
What are the different types of collation sensitivity?
What is 3nf normalization form?
How many tables can be joined in SQL Server?
What are secondary xml indexes?
Describe the left outer join & right outer join. : sql server database administration
Which is faster statement or preparedstatement?
What is a View ? Can we insert, Update and delete a view?
What is dml command?
How do I create an extended event in sql server?
What is dknf in normalization form?
Data table as parameter in sql server?
What does dml stand for?
Is sql server implemented as a service or an application? : Sql server database administration
