Friday, 8 July 2016

What is database deadlock? How can we avoid them?

Database deadlock
When multiple external resources are trying to access the DB locks and runs into cyclic wait, it may make the DB unresponsive.

Avoid Database deadlock
1. Can make a queue wherein we can verify and order the request to DB (To run the operations in FIFO order).
2. Less use of cursors as they lock the tables for long time (slow down the DML executions).
3. Keeping the transaction smaller (process query relation operation before start the transactions).

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...