sql server drives

• chewychewy

  Hall of Fame

  Points: 3126

  More actions

  May 17, 2016 at 8:21 pm

  #326376

  Hi Guys,

  Any concerns i should be aware of if i place the .mdf (system + users) together with the SQL binaries?

  C:\ OS

  D:\ SQL Binaries + .MDF

  E:\ .LDF

  thanks

• kreuzer

  Ten Centuries

  Points: 1236

  More actions

  May 18, 2016 at 12:50 am

  #1879747

  Hi,

  I think, it "depends" on your database. What kind of application would you use?

  If you have lots of IO, or a OLTP/OLAP, you need different drives with different speed.

  The msdb, master and model database need not to be stored on very fast and expensive harddrives.

  The TempDB should be stored on the fastest drive, maybe some kind of SSD. Create a drive for your user-mdf and for your user-ldf files.

  Let uns know the size and some more information of your application/database.

  Kind regards,

  Andreas