SQL Server

Gost101 · January 7, 2019

Hello everyone.

I'm looking into creating an SQL server for an app that I have been making. I'm at the point in the apps creation in which I cannot continue until I create a sever for it. What would be recommend for approximately 1000 users whom will be periodically using the server with a storage capacity of 20TBs. My budget is around $2000. If I can go cheaper that would be great, but if I have to go more a bit I can work with that. My current internet connection is sadly 80mbs down and 10mbs up. However hopefully today it will be upgraded to 140mbs down and 20mbs up. Until I can move to continue development or until I can hand it over to the gaining agency, I'm stuck with this internet connection. Thank you for your time and help over this matter.

Jeroen V · January 7, 2019

Which OS and DB are you planning to use? If you say "SQL Server" I expect it will be Microsoft SQL Server, and if that is the case then be prepared that the licenses are not cheap. You could go with SQL Express 2017 but that has a limit of 10GB per database....

NelizMastr · January 7, 2019

MSSQL won't fit your budget, not with 1000 users anyway. I assume data traffic is rather low, as there's no way to run this off a 20mb up connection otherwise, so you might be fine with a solution like mysql or mariadb. You'd have to test to see how that performs. SSD storage is recommended for a database.

nobrain · January 8, 2019

Drop SQL Server in favour of PostgreSQL or MariaDB. SQL Server is more tailored towards enterprise applications and the pricing is just atrocious for anything other than large businesses. PostgreSQL or MariaDB will do the job just fine and perform better in a lot of instances, and for your use-case they are more than adequate.