SSD or SAS Drives

• SqlServerDBA318

  SSCrazy

  Points: 2353

  More actions

  August 13, 2015 at 10:33 am

  #310895

  I just got the green light to shop for a new box.

  We use 2014 BI edition and will get the 128GB of Memory.

  This is an OLAP environment so my question is what is better to have for disks?

  SSD or SAS?

  Any insight / suggestions would be greatly appreciated.

  Thanks!

• K. Brian Kelley

  SSC Guru

  Points: 114532

  More actions

  August 14, 2015 at 2:29 pm

  #1820223

  This depends greatly on your I/O and very much becomes a question of cost vs. performance. Do you have any kind of numbers around that?

  K. Brian Kelley
  @kbriankelley