Interested to Buy Any Domain ? << Click Here >> for more details...
What is deadlock and how to avoid the deadlocks.
- 3 Answers
- 10805 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 system stored procedures?
How to download and install microsoft sql server management studio express?
What are alternate keys?
What is a mixed extent?
how many triggers you can have on a table? : Sql server database administration
What is subquery in sql?
What does truncate do?
What are built in functions?
explain declarative management framework (dmf) in sql server 2008?
How to create a view on an existing table in ms sql server?
How to use linked server?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
What do you understand by coalesce in sql server?
What are scheduled tasks in sql server?
What is the difference between resultset and resultsetmetadata?
