Improve stability and commit throughput under high DBRAM load

Detail name	Value
Changelog Number	23062
Type	Improvement
Status	Resolved
Fix Versions	Exasol 2026.1.0
Resolution Date	2026-05-15

Background

SQL connections can generate large amounts of temporary and persistent data, which can place a significant load on the DBRAM. Under very high load, commit and rollback operations may take longer, as the database requires the DBRAM itself for internal updates. In severe cases, this can reduce throughput and cause the database to become unresponsive. This situation is often triggered by faulty SQL statements or other problematic workloads.

Improvement

The database now reserves dedicated DBRAM memory for internal update operations during commit and rollback operations. This ensures that critical database operations can continue even under heavy load, which improves commit throughput and reduces the risk of long delays or a loss of system responsiveness.