SQL Server Performance

Installing SQL 2008 R2 on Windows 2008 R2 standard 64bit

Discussion in 'SQL Server 2008 Performance Tuning for DBAs' started by drose789, Dec 5, 2010.

  1. drose789 New Member

    I am installing SQL 2008 R2 on a new Windows 2008 R2 server for a client
    The server has the OS installed on a Raid 1 (c Drive)
    And it has 3 additional containers, 2 Raid 1's and one Raid 10. I am assuming I shouold use one Raid 1 for the logs, One for the Temp DB, and the Rain 10 for the databases. I also assume the SQL install files will go on the Raid 1 (OS)
    My question is do you have a document to follow for the best possible install of SQL based on the machine layout? What do you recommend.
  2. satya Moderator

    Welcome to the forums,.
    Why to put SQL binaries on RAID, better keep them on C: drive along with operating system files. Rest all looks good, btw do you have what kind of application is using this SQL instance is it OLTP or OLAP based?

Share This Page