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?
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 ;)– TomTomAug 27, 2017 at 10:07
The benefits of SSD are self-explanatory. The downside is cost.– Dan GuzmanAug 27, 2017 at 11:40
You already know the answer for this, it is FAST.
Here are very basic and known benefits of using SSD.
Keep your databases in SSD will handle more IO in very less time.
Keep temp DB in SSD, obviously, it will improve the performance of the queries.
We can use SSD as buffer pool (extension).