I have a database in Full Recovery mode. Full backup is executed every day, transaction log backup every hour.
SELECT* FROM sys.dm_os_performance_counters where counter_name = 'Log Truncations'
shows 0 log truncations for that DB.
At the same time,
shows different "Log Space Used" after each execution (it slowly grows during interval between log backups, and then drops; Log Size doesn't change), so it seems to me that log truncation works fine; otherwise, I'd run out of space long time ago.
I suspect counter is not updated for any reason, but I can't figure out why. Also, I may be well wrong, and the problem is more serious than it looks .
Any help is greatly appreciated.