The Transaction Log Usage fluctuating quite frequently.
When I run
DBCC SQLPERF('LOGSPACE') it shows
Log Space Used (%) as
3% which is like
650MB while at very next minute or two when I run it again it might show as 0.0123% without doing any kind of Log backup or anything and it happened few times.
Just wondering what it could be? I was trying to analyse Log usage pattern over the period of time.
Thanks in advance