SQL Server Web vs Standard edition SQL Server Web vs Standard edition sql-server sql-server

SQL Server Web vs Standard edition


The differences between web and standard version of SQL Server 2016 are listed here : https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016

Main differences between web and standard are the max memory and max number of cores. Both web and standard version don't have the possibility of online indexing, this is only possible in the enterprise edition.

For a database size having a size of around 200GB, the web edition looks to be ok. But this depends also on the workload of the database, are just some users querying this database or is this database used by thousand of users.