Locking and performance

Locking affects the Adaptive Server performance by limiting concurrency. An increase in the number of simultaneous users may increase lock contention, which decreases performance. Locks affect performance when: