I'm start to using the memory optimized table, the problem that I have is the log file growth also with the database put in simple mode.
On my maintenance schedule I checkpoint and shrink, but still has the issue. If I revert back the tables to normal disk table, everything looks fine.
Did somebody know the reason?
The database has the column
LOG_REUSE_WAIT_DESC to 'nothing' in
All the mem opt tables are in SCHEMA_ONLY modality, but still full logging.
SQL Server 2017 version 14.0.3037
I also see these messages in the SQL Server error log:
spid38s,Unknown,[INFO] Database ID: . Deleting unrecoverable checkpoint table row (id: 669)
spid102,Unknown,[INFO] HkHostFreezeCkptTrimming(). Database ID: . HkTrimLSN Frozen: 1
spid102,Unknown,[INFO] getMaxUnrecoverableCheckpointId(). Database ID: . Start of Log LSN: 00001714:000004E0:0002 used to trim unrecoverable checkpoint files tables during full backup