My Logfile keeps auto grow even though approximately only half of the VLF is used, can anyone explain this?
See picture below. I truncated the logfile yesterday, this is the first load since and from my understanding the ones which have 0 as vlf sequence number haven't been used. But still the logfile auto grew, the one which have 150 in vlf_size_mb is auto grow. How come this happened?
picture below with not the same lsn, lsn last column.
Here is from the sys.trace_event as you can see the log did auto grow, does anyone know how this can happen without the VLFs beeing used?