Hard Drive for SQL Server

Horse06
Horse06 Member Posts: 496
edited 2013-10-03 in NAV Three Tier
Hi expert, If I leave the data file, log file and tempdb file in C drive as default without Raid, does it affectt the speed of the system? Thank you!

Comments

  • geordie
    geordie Member Posts: 655
    Usually it's better to place data file, log and temp on a different disk than the operative system: in this case even if OS perform any heavy operation, the database doesn't slow down.
    Of course there's some kind of risk using a non-raid drive.
    * Daniele Rebussi * | * Rebu NAV Diary *
  • bbrown
    bbrown Member Posts: 3,268
    Absolutely it affects the performance of the system. But it's all relative. Spend some time reviewing the many post you will find on the subject. But in general, a default (everything on C) may be adequate for a tiny demo system but little else.
    There are no bugs - only undocumented features.
  • Horse06
    Horse06 Member Posts: 496
    Thank you for all your advice, experts! But if we don't have many users (around 20), is it very necessary we install the SQL Server using the Raid configuration? Thank you!
  • geordie
    geordie Member Posts: 655
    In my opinion 20 users is not a little quantity at all: a Raid0 stripe can improve the performance for sure, but I suggest a Raid10 to prevent data loss.
    * Daniele Rebussi * | * Rebu NAV Diary *

Categories