SQL Edition

Matthew H asked on January 28, 2022 09:12

Dear,

Which Microsoft sql edition can i use for a kentico website that are hosted onprem ? Is the web edition enough ? Perhaps the express setup could do the job ? Or do i have to use the standard edition which is more expensive ?

Is there "any rules" to determine which version i have to used ?

Thanks all !

sql server

Correct Answer

Technical support leader

Juraj Ondrus answered on January 28, 2022 12:16

Well, yes - but then this is more question for SQL community to give you some idea what edition can handle what load. Kentico does not care what SQL server edition you are using.

0 votesVote for this answer Unmark Correct answer

Recent Answers

Dmitry Bastron answered on January 28, 2022 09:33

Hi Matthew,

According to the docs even the Express version will do, however for production websites I wouldn't recommend it.

0 votesVote for this answer Mark as a Correct answer

Matthew H answered on January 28, 2022 09:43 (last edited on January 28, 2022 09:44)

Hi Dmitry,

And for production websites is the web edition enough ? What are you recommendations between the standard and web edition for a "classic" website as we encountered all days :) ?

0 votesVote for this answer Mark as a Correct answer

Technical support leader

Juraj Ondrus answered on January 28, 2022 11:39

This depends on what load the SQL server should handle - so it depends on the project and its implementation.

0 votesVote for this answer Mark as a Correct answer

Matthew H answered on January 28, 2022 11:44

Dear Juraj,

So, if the server load match the web edition limitation, i can use it without any "licensing" trouble ? The license price is very different from web to standard, so that's why i'm asking.

0 votesVote for this answer Mark as a Correct answer

Matthew H answered on January 28, 2022 14:30

Thanks all for your clarification !

0 votesVote for this answer Mark as a Correct answer

Eugene Paden answered on February 16, 2022 21:09

Hi Matthew,

Kentico uses the basic SQL DB Engine features, so the Web edition should be enough for you, unless you want to use other SQL Server features, e.g. clustering, data warehouse, analysis services, etc.

Please note also the Scale limits for Web edition which I think should be enough for your needs.

This document can help you https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-version-15?view=sql-server-ver15.

0 votesVote for this answer Mark as a Correct answer