How is the contention when writing to the ldf files? If I know well, multiple log files do not help. But why? Why does not take the advantage of parallel (and proportionally) log writing? Am I correct that these files should be placed on different physical drives too? How does it apply to SAN drives?
