Enterprise - Unlimited memory, Standard - 32 GB, Web - 16 GB, Express - 352 MB. GeoPITS brings you the comprehensive details of Maximum memory for Columnstore segment cache per instance of SQL Server Database Engine's support in different versions & editions of SQL Server.
| Version | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Version v2019 | Unlimited memory | 32 GB | 16 GB | 352 MB | 352 MB |
| Version v2017 | Unlimited memory | 32 GB | 16 GB | 352 MB | 352 MB |
| Version v2016 | Unlimited memory | 32 GB | 16 GB | 352 MB | 352 MB |
| Version v2014 | Unlimited memory | 32 GB | 16 GB | 352 MB | |
| Version v2012 |
Enterprise - Unlimited memory, Standard - 32 GB, Web - 16 GB, Express - 352 MB
You can find more details about this version here
Back to all features