Hard Drive for SQL Server

Comments

• Options

  geordie Member Posts: 655

  2013-09-27

  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 *

  0
• Options

  bbrown Member Posts: 3,268

  2013-09-29

  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.

  0
• Options

  Horse06 Member Posts: 496

  2013-09-30

  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!

  0
• Options

  geordie Member Posts: 655

  2013-10-03

  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 *

  0