• jansub07 (6/7/2012)


    MDF and LDF in different locations make any sense in performance of SQL?

    Generally speaking, yes, but depends what "locations" means.

    In order to increase performance, they must reside on different physical disks. This means different spindles, not logical volumes on the same spindles.

    Data and log files are read and written with very different I/O patterns:

    data files --> mostly random reads and writes

    log files --> mostly sequential writes

    Separating those I/O patterns can improve performance and recoverability.

    Hope this helps

    Gianluca

    -- Gianluca Sartori