What is the difference between SQL Server standard and web edition?

Question

Is there any technical difference between these 2 editions or is it just how they are licenced?

score 43 · Answer 1 · edited May 10 '20 at 14:19

43

Since newer version(s) of SQL Server have been released, the feature comparison is tucked away in MSDN:

edited May 10 '20 at 14:19

ihebiheb

103

answered May 01 '12 at 18:05

Jim Geurts

677

2

Any chance we could get a link for SQL Server 2017? – Cullub May 23 '18 at 17:48

George Filippakos · Accepted Answer · 2012-08-24T08:54:07.870

32

Here you can find a comprehensive comparison :

http://msdn.microsoft.com/en-us/library/cc645993%28SQL.105%29.aspx

Please note: the Web edition does come with SQL Profiler and management studio

edited Aug 24 '12 at 08:54

answered Aug 22 '12 at 19:43

George Filippakos

544

9

The Web edition 2012 and 2014 don't come with SQL Profiler anymore. – user220388 May 20 '14 at 13:04

score 23 · Answer 3 · edited Nov 26 '14 at 06:44

23

They're close, but not quite the same. The primary difference is the licensing (as you mention). The other differences are around mirroring (web can only serve as a witness), publishing (web can only subscribe), and performance (web does not come with SQL Profiler).

There are more differences when you get out of the SQL Engine and into SSIS, SSAS, and SSRS.

Full comparison of all editions here

edited Nov 26 '14 at 06:44

masegaloeh

18,376
10
58
110

answered Dec 12 '09 at 18:18

Sean Earp

7,257

Can you elaborate tuning part of SQL server web edition 2019? – Furkan Gözükara Apr 26 '21 at 13:30

What is the difference between SQL Server standard and web edition?

3 Answers3