Retour
-
Titre
Will having multiple online SQL Server transaction log files increase performance? -
Description
When do we need to have multiple online SQL Server transaction log files? -
Résolution
This myth is based on the belief that having multiple online transaction log files will result in parallel writing of transactions into the files and therefore result in performance gain. SQL Server can’t operate with more than one online transaction log file at the time, so any kind of parallel I/O is not possible.
Having multiple transaction log files is needed only in the situations where the initial SQL Server transaction log can’t record more transactions due to a lack of free space on the disk.
Find more information on the SQL Server transaction log topic in the 10 most important SQL Server transaction log myths article.