Why are virtual log files slow?

extreme-cases transaction-log brent-ozar-unlimited log-file-vlf

Post a Reply

Vidhant

The number of virtual log files can grow based on the autogrowth settings for the log file and how often the active transactions are written to disk. Too many virtual log files can cause transaction log backups to slow down and can also slow down database recovery, and in extreme cases, even affect insert/update/delete performance.
For More Information Please Refer:


You May Also Like to Read: