Lock contention can impact Adaptive Server throughput and response time. Consider using locking during database design (for example, to avoid joining a high number of tables during queries), and monitor locking during application design.
Address locking contention by changing the locking scheme for tables with high contention, or redesigning the application or tables that have the highest lock contention. For example:
Add indexes to reduce contention, especially for deletions and updates.
Keep transactions short to reduce the time that locks are held.
Check for contention “hot spots,” especially insertions on allpages-locked heap tables (a heap table is a table that has no clustered index).
