SQL Server Performance

SQL Service Installation Disk Choice

Discussion in 'Performance Tuning for Hardware Configurations' started by ntullis, Sep 26, 2006.

  1. ntullis New Member

    Simple question,

    Does it matter what disk the actual installation (meaning the MSSQL and Agent service, and maybe system DBs) is installed on as long as the data and log files are located on properly configured high performance disk systems? Or should it be installed on say the same array the datafiles reside on?

  2. catullus Member

    It shouldn't matter much, except for the location of the tempdb database. If you use that a lot, you could put tempdb on a seperate RAID set. I only put the log files and data files from user databases on their own RAID sets (where possible).

    Early morning, when I wake up,
    I look like Kiss but without the makeup

    --Robbie Williams, Strong
  3. Chappy New Member

    Id put all system DB's on a raid config of some kind rather than C:, if possible.
    Not necessarily for performance, just for fault tolerance
  4. ntullis New Member

    I see, thanks for the input.

Share This Page