sys.dm_db_log_stats :log_truncate_holdup_reason : OLDEST_PAGE

Question

for full mode database, I did some transaction , and then backup the transaction log . and then I will see sys.dm_db_log_stats :log_truncate_holdup_reason : OLDEST_PAGE

there is some definition on the following but I am still a bit confused of this reason .
https://www.mssqltips.com/sqlservertip/4666/long-running-transactions-cause-sql-server-transaction-log-to-grow/

Answer 1

Hi michaelchau,

If a database is configured to use indirect checkpoints, the oldest page on the database might be older than the checkpoint log sequence number (LSN). In this case, the oldest page can delay log truncation.
You can create CHECKPOINT manually, then backup transaction log again.
Please refer to Factors that can delay log truncation and this similar thread which might help.

Best Regards,
Amelia

Answer 2

so in my example, the database is having 60s target_recovery_time, but wait for about more than many minutes. it's still showing ÖLDEST_PAGE

so where is the oldest_page ?