Timesten - Transaction Log

> Database > (TimesTen|TT) (In-Memory Database|IMDB)

1 - About

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.

Advertising

3 - Buffer

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

LogFileSize=1024 
LogBufMB=1024 
LogBufParallelism=16 

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;