3702536 - Latch contention reported on a Very Large Database (VLDB) - ASE

• sp_who show process in "latch sleep"
• Optdiag shows many Forwarded rows and deleted rows

Data row count:                                                            599864523.0000000000000000
Forwarded row count:                                                       383599646.0000000000000000
Deleted row count:                                                         30559764.0000000000000000

• dbcc listoam show many OAM bit that needs to be set

The bit for alloc page -1708018944 in database 18 is clear. It should be set

• Allocating space on a VLDB can lead to latch contention if most of the space is allocated at the end of the database
• Logical I/O (LIO) is extremely elevate when latch contention is reported

SAP Adaptive Server Enterprise (ASE) 16.0 SP04 PL04

CR 831673, 831673, latch, high cpu, allocation, OAM, Object, Allocation, Map , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement