Interested to Buy Any Domain ? << Click Here >> for more details...
What is deadlock and how to avoid the deadlocks.
- 3 Answers
- 10945 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
How to disable triggers using "disable trigger"?
what is the different types of backups available in sql server? : Sql server database administration
What are the different types of join?
What is mscorsvw.exe - process - microsoft .net framework ngen?
Name few of the dcl commands in sql?
Define a cross join?
How do you send email on SQL Server?
How you can change a cross join into an inner join?
How to retrieve field values using mssql_result()?
How many types of cursor type are there?
What are types of subqueries?
What will be query used to get the list of triggers in a database?
What new changes are being made in SQL Server?
What is named calculation? : sql server analysis services, ssas
What is t-sql script to take database offline – take database online.
