Do I need a separate SSD for SQL?

Question

RAID

We are assembling a server on which there will be a 1C + SQL machine in the hypervisor. Specifically for this couple, there will be RAID 10 with SSDs, which, according to the calculator, give about 200k IOPS (4x Samsung 950 Pro 512Gb). The question is, do you still need to split the log file and data file on different disks, or can you leave everything together on one array?
Thank you in advance.

Answer 1

And I'll add one more. Just last month we went through a similar situation - we got a request that runs on our server for a very long time, 15 seconds. Installing an SSD and transferring the base to it gave an acceleration of about 0.5 seconds. Query optimization, by simply transferring the nested query to a temporary table, reduced the query execution time to 1 second (i.e., 15 times). This is me to the fact that the SSD itself will not solve all the problems.
PS: And yes, of course, it’s right to keep the logs on a regular disk (and in general, decide why you need such a recovery model if everything is on raid 10), and don’t forget to transfer tempdb to the SSD.