Answer the question
In order to leave comments, you need to log in
What is the performance of MS SQL Express 2012?
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 the question
In order to leave comments, you need to log in
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 .
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question