DEAD LOCK
WHEN DEAD locks occur
1. Different transactions trying to accessing the same table object
2. Log running quires
3. Lack of proper indexing
4. Poorly written code
5. Hardware bottlenecks
6. Higher Isolation level(other than Read committee)
No comments:
Post a Comment