Does it make sense to install MS SQL Server on an SSD?

K

Konstantin2015-09-23 12:14:29

Solid State Drives

Konstantin, 2015-09-23 12:14:29

Good afternoon!
Actually, the question is simple: is there any reason to install MS SQL on an SSD? Will this provide any speed advantage for database applications? Or should you not bother and use the HDD in the old fashioned way?

Reply

Answer the question

In order to leave comments, you need to log in

4 answer(s)

D

Dmitry Kovalsky, 2015-09-23
@dmitryKovalskiy

The question about SSD on a DBMS was raised more than once here. The general answer is that there will be "some" speed advantage. But you need to be firmly confident in the optimality of your own scripts.

M

Max, 2015-09-23
@MaxDukov

how many tangible pluses there will be only under the condition of a large volume of read / write operations with the disk (which is not good in any case and most likely indicates that the structure of the database / queries is not optimal).
how long the disk will live - again, it depends on your database, on the frequency of writing to / updating database records. If the database works mainly for reading, the disk will live for a long time.

V

Vlad Zhivotnev, 2015-09-23
@inkvizitor68sl

Depends on base and on what scripts rest against.
But the general answer is "yes, if the base doesn't lie entirely in RAM". The only question is, will you notice it.

A

Artem @Jump, 2015-09-23
Tag curated by

You need to monitor the disk queue and disk load. Then it will be clear whether the SSD will give some increase in performance.
An SSD will definitely work an order of magnitude faster than an HDD, but if you have enough HDD speed, then what's the point?
As for how long it will live, it depends on the amount of data recorded by the database per day, on the size of the disk, and the type of memory used.
If we talk about an average household SSD on an MLC with a size of 256GB, then approximately
100-200GB per entry per day - 5 years.
300-400GB per day -2 years.
terabyte per day - 1 year.