Dotyczy SQL Express 2017, 2019, 2022 .
CPU limited to lesser of 1 socket or 4 cores – (SQL Server Standard allows for 4 sockets or 24 cores)
10 GB limit on Database Size – (SQL Server Standard allows for up to 524 PB)
Maximum buffer pool memory (per instance) limited to 1410 MB – (SQL Server Standard is 128 GB)
Maximum columnstore segment memory (per instance) limited to 352 MB – (SQL Server Standard is 32 GB)
Maximum memory-optimized data size (per database) limited to 352 MB – (SQL Server Standard is 32 GB)
Sprawdzenie używanej wersji SQL Server:
https://learn.microsoft.com/en-us/troubleshoot/sql/releases/download-and-install-latest-updates
SELECT @@version;lub
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition');