Answer
Latches protect internal memory structures and are non-transactional.
Locks protect logical data consistency and last for transaction duration.
Latch waits = engine pressure.
Lock waits = concurrency or blocking issues.
Quick Answer
Latches are lightweight, short-lived synchronization objects for physical consistency of in-memory pages — they don't appear in deadlock graphs and aren't tracked like locks. Locks are for logical, transaction-level concurrency — they persist for the transaction duration and show up in blocking queries and deadlocks.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ