I have a DB on a SQL Server 2014 instance. I have a memory-optimized filegroup, but as yet, no memory optimized tables. I also have a FILESTREAM filegroup, which contains 1 FILETABLE and a Primary filegroup which contains several tables.
I am in FULL recovery model.
My transaction log is not being reused. It just keeps growing. The Log_Reuse_Wait_DESC is xpt_Checkpoint. I believe this means it is waiting for a memory optimized checkpoint.
The database and the transaction log have been backed up. I have also tried issuing a checkpoint, as I know this also triggers a memory optimized checkpoint.
Looking inside DBCC LOGINFO, I can see that all of the VLFs are marked as active, despite there being no open transactions.