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.
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.
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ