Following is a brief comparison between MSSQL Server 2016 Express Edition and MSSQL Server 2016 Web Edition.
| Features | SQL Server 2016 Express (with Advanced Services) |
SQL Server 2016 Web |
| Cost | Free of Cost | Core-Based Licensing ($30/month for up to 4 Virtual Cores) |
| Number of CPUs Supported | 1 | 4 |
| Maximum computing capacity used by a single instance - SQL Server Database Engine |
1 socket or 4 cores | 4 sockets or 16 cores |
| Maximum computing capacity used by a single instance - Reporting Services |
1 socket or 4 cores | 4 sockets or 16 cores |
| Maximum Memory Utilization (per instance of Database Engine) |
1GB | 64 GB |
| Maximum Database Size | 10GB | 524 PB |
| Maximum Memory Utilization (per instance of Reporting Services) |
4 GB | 64 GB |
| Multi-Instance Support | 50 | 50 |
| Transact-SQL Endpoints | No | Yes |
Looking to verify your existing MSSQL Edition. Please refer to MSSQL > Check Edition for more details.
