What is the best configuration for a DB server?

Question

Database design

I'm thinking about this configuration:
Intel Atom C2758 2.4 GHz
2 × 240 GB SSD
16 GB RAM
Processor and hard drive information is clickable.
OS: Microsoft Windows 2012 R2 Standard
DB: SQL Server 2014 Express (maybe later standard)
What the server will do:
1) process user requests via http/https up to 200 per second
2) perform simple operations in the database.
- choose from 1 million records one by primary key (the most frequent operation)
- insert records.
- a selection of the latest added
Database size 3GB
Now the database is 100 thousand users and the speed of these queries: 0.02ms -0.04ms
We use: Intel Core 2 Duo E8400 3 GHz 6 GB 2 × 500 GB SATA
Well, questions:
1) Should I use an SSD for the database?
2) Should I use these SSDs? This particular company?
3) Will this processor be enough (as it has proven itself)?
4) Is SQL Server 2014 Express sufficient with its limitations? Or will there be no benefit to the new configuration?

Answer 1

1) Yes, but not critical.
2) Yes
3) Depending on what you mean by the word enough. The processor is at least two times less productive than the current one, so the speed of work will, of course, be less.
4) It's better for you to know, quite a bit of information to say something. Is 1GB enough memory for you or not?
Whether it will be useful or not is unknown. But it will obviously work more slowly, because the processor is weaker.