I'm using AdventureWorks database in Simple Recovery Model on SQL Server 2016 Ent, and I'm examining the active VLFs.
select * from sys.databases shows ACTIVE_TRANSACTION under log_reuse_wait_desc
but when I run
dbcc opentran to figure out which session, i get "No Active Open Transactions"
There does seem to be a background task running, which prevents me from taking the database offline
Status DBName Command
BACKGROUND AdventureWorks XTP_OFFLINE_CKPT
There is also a full-text catalog (which gets crawled regularly I guess?)
How do I find out what transaction is holding up my log VLFs ?