EPiServer 11 and SQL Server Web Edition

Ger Groot

Vote:

Hi everyone,

For a customer we are considering the use of Sql Server Web edition over the Standard edition.
Does anyone know if there are there limitations in the Web edition or other arguments why it is better to stick to the Standard edition?

thanks in advance!

#204952

Jun 24, 2019 10:13

Quan Mai

Vote:

Sql Server Web edition supports only 64GB of RAM and does not have SQL Profiler bundled. It also has no "tuning advisor".

I don't see those to be major issues for you, but if you have a very big Episerver site then you might want to stick with Standard edition.

My recommendation is to consider DXC so you don't have to worry about all of these.

#204955

Jun 24, 2019 10:55

Vote:

Hi Quan, yes we are also considering the DXC but we also have to consider the on premise option.

Regarding the requirements, we don't need 64gb and the tuning adviser so I guess we are good with the Web edition.

thanks!

#204957

Jun 24, 2019 11:26

Henrik Fransas

Vote:

For a small/medium site the web edition works very good and regarding Profiler I think you can run SQL Trace (that is the thing running when running Profiler) on it.

So I think you will be fine with web edition.

#204982

Jun 24, 2019 20:02