Timesten - Transaction Log


Changes to databases are captured in transaction logs that are written to disk periodically.

Log records are generated with the execution of INSERT, UPDATE and DELETE operations.

Normal disk file systems are used for transaction log files.


Server DSN Connection attribute in order to set the properties of the Log Buffer.


The TimesTen transaction log buffer size has a default size of 64 Mb.

If your application is write intensive, creating a bigger memory log buffer reduces log contention and avoids log buffer waits.

You can monitor the LOG_BUFFER_WAIT value for I/O contention and increase its size if needed:

select LOG_BUFFER_WAIT from sys.MONITOR;

Powered by ComboStrap