Answer
Lock escalation converts many row/page locks into a single table lock to reduce overhead.
Impact:
- Fewer locks = lower memory use
- But higher blocking risk
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ