pooyan_pdm (2/14/2014)
The final destination of the dirty pages is the data files but they should be pushed to the log file before or at the same time they are being pushed to the data files.
Data pages do not get written to the log. Data pages get written to the data file. Log entries get written to the transaction log.
so what makes the Log cache to be flushed to the log file?
Already answered that one
log buffer flushes either because it's full or because some other transaction has committed or any of the dirty data pages need to be written to disk.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability