I've newly taken over administration of a system with about 25 databases. Using Redgate Monitor to chart some metrics, I see that each day, one database shows values for log flushes / second that look like a "normal" chart - a zig-zag line throughout the day.
Redgate explains the metric: "A log flush occurs when a transaction is committed and data is written from the log cache to the physical transaction log file."
All well and good - work is happening and data is getting flushed to disk as it commits.
My question is - why do all the other databases fail to register anything much above the x-axis at all?
Redgate also explains: "Log flushes per second should generally correlate with the number of transactions per second."
When I view transactions per second, plenty of databases are showing zig-zag chart lines - so what's going on that only one of them is showing activity for log flushes? Does this mean all the other databases are failing to commit?
All user databases are using full recovery model.
(I also note between 2am and 5am there are huge spikes in log flushes for almost all databases - still to investigate the cause of these).