SQL Server Web vs Standard edition

sql sql-server performance sql-server-2008 database-indexes
User987 picture User987 · Feb 24, 2018 · Viewed 66.8k times · Source

I have found out that there's two versions of SQL Server types that are very different in terms of pricing...

The Web version from my host provider costs about 13$ per 2 core packs, whereas the Standard edition is right around 200$.

From my standpoint, we expect our database to be around 150-200GB in size, only few tables would take up most of that space.

So my only concern is would the web version of SQL Server support this large database and not cause any performance issues to the end users?

How different is index rebuilding on Web and Standard version?

Can someone help me out with this?

Answer

Tom V picture Tom V · Feb 24, 2018

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.

Related questions

SQL Server SELECT LAST N Rows

This is a known question but the best solution I've found is something like: SELECT TOP N * FROM MyTable ORDER BY Id DESC I've a table with lots of rows. It is not a posibility to use that query because …

Read More
Multiple INSERT statements vs. single INSERT with multiple VALUES

I'm running a performance comparison between using 1000 INSERT statements: INSERT INTO T_TESTS (TestId, FirstName, LastName, Age) VALUES ('6f3f7257-a3d8-4a78-b2e1-c9b767cfe1c1', 'First 0', 'Last 0', 0) INSERT INTO T_TESTS (…

Read More
Why is a UDF so much slower than a subquery?

I have a case where I need to translate (lookup) several values from the same table. The first way I wrote it, was using subqueries: SELECT (SELECT id FROM user WHERE user_pk = created_by) AS creator, (SELECT id FROM …

Read More