Answer
When too many row/page locks exist, SQL upgrades to a table lock. This reduces overhead but lowers concurrency.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ