SQL Server Performance

Location of MDF and LDF files...

Discussion in 'Performance Tuning for Hardware Configurations' started by tkelley, Nov 5, 2003.

  1. tkelley New Member

    Is it more efficient to store your MDF and LDF on the same server as your SQL Server installation or move them to a seperate server?

    ----------
    T Kelley
    MS, MCDBA, OCA, CIW

  2. satya Moderator

    Yes it is efficient to keep them on seperate drives in terms of performance gain and so it will be on same server.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  3. Luis Martin Moderator

    I don't follow, you mean one server with SQL Server Installation and other server with SQL Server Production, to replicate, 1rs to backup of second?



    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
  4. tkelley New Member

    Similar to what satya described.

    For example:
    Drive C: has the OS (RAID 1)
    Drive E: has the SQL Server installation files (RAID 5)
    Drive F: has the Production data and log files (RAID 5)

    I don't think it would be as efficient to store the data files on a completely seperate server. Do you? Then SQL Server would have to make a network call to the data files.



    ----------
    T Kelley
    MS, MCDBA, OCA, CIW

  5. Luis Martin Moderator

    Ok. I undertood another server, no another drive. This case, agree with Satya.

    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell

Share This Page