Diagnosing Lock Contention
- 30 Downloads
Lock issues is one of the common causes of performance issues, and the impact can be severe. In the worst cases, queries can fail, and connections pile up so no new connections can be made. Therefore, it is important to know how to investigate lock issues and remediate the problems. This chapter analyzes four categories of lock issues: flush locks, metadata locks, record-level locks, and deadlocks. Each example includes the symptoms, the cause, the investigation, the solution, and how to prevent the issue are discussed.