-2

If we put the launch time aside, what are the benefits of installing your SQL server (along with your databases) in SSD instead of HDD?

Improve this question
2
  • You really ask about the difference of "up to around 450 IOPS" (15k SAS SSD) and "20.000+ IOPS"? SSD are regularly - even cheap ones - 100 times faster in IO capabilities. Guess what databases love ;)
    – TomTom
    Commented Aug 27, 2017 at 10:07
  • The benefits of SSD are self-explanatory. The downside is cost.
    – Dan Guzman
    Commented Aug 27, 2017 at 11:40

1 Answer 1

Reset to default
0

You already know the answer for this, it is FAST.

Here are very basic and known benefits of using SSD.

  1. Keep your databases in SSD will handle more IO in very less time.

  2. Keep temp DB in SSD, obviously, it will improve the performance of the queries.

  3. We can use SSD as buffer pool (extension).

Improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.