What is the performance of MS SQL Express 2012?

Question

SQL Server

Hello. Perhaps the questions are stupid, but I hope you clarify.
1. It is supposed to operate a server application implemented on asp.net mvc in conjunction with MS SQL Express.
2. Data volume: for 8000 people, approximately 200 records for each ((the figure is too high, backlog) (the table is relatively small: full name, date of birth, address, line for entering records (length 300).
3. It is assumed that "server" will be accessed by up to 10 users. No more than 5 people per hour. It will be possible to add records of information about a person, search, update.
4. Questions are:
and I know the process, I'm interested - it is with these restrictions in mind)
b. How productive "server" (hardware) is needed for these purposes?
in. Can you tell me how to do "load testing"?
Thank you for your attention.

Answer 1

Your database (~500MB) will fit entirely in RAM on any computer. Your users will load the SQL server minimally. In anticipation of the release of SQL 2019, you should not use 2012. Many add-ons work from version 2016.

what add-ons are you talking about?

Compare versions of Microsoft SQL Server .