What is deadlock and how to avoid the deadlocks.
- 3 Answers
- 10101 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
What is order of B+tree?
How except clause is differs from not in clause?
What is the difference between dbcc indexdefrag and dbcc reindex?
What are audit control procedures?
What are the differences between local and global temporary tables?
what are the important architecture components of SSRS?
What is a trace frag?
Define model database?
How to grant a permission in ms sql server using "grant execute" statements?
What is table join?
Explain the working of sql privileges?
How to get the number of affected rows?
What are synonyms?
Which command is used for user defined error messages?
What is standby servers? Explain types of standby servers.
