Best solution for SQL server?

Question

I build computers and a customer wants a server for their SQL database. It will have up to 5 workstations accessing the database at any given time. The database is currently 10GB but could grow to 50GB over the next few years. He wants the best possible speed for accessing and working with the database.

What makes a good SQL server?

ECC vs non-ECC and buffered vs un-buffered memory? The database is for his professional business.

Will faster DDR4 3200+ RAM help make things faster and still be okay without being ECC?

What about a super fast PCIe SSD?

Answer 1

https://www.mssqltips.com/sqlservertip/3235/sql-server-hardware-configuration-best-practices/

>>>What makes a good SQL server?

Many things like described in the above link, but also in order to speed up the queries you need  properly defined indexes  otherwise you'll see performance degradation even on modern hardware 

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence

Answer 2

Hi Encom88,

If you want to use SQL Server 2017, you would like to refer to Hardware and Software Requirements for Installing SQL Server.

---

Best Regards,
Puzzle
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]