SQL Server Enterprise edition allows a maximum buffer pool extension size of 32 times the value of max_server_memory. SQL Server Standard edition allows a maximum buffer pool extension size of 4 times the value of max_server_memory. GeoPITS brings you the comprehensive details of Maximum capacity for buffer pool extension 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 | Operating System Maximum | 128 GB | 64 GB | 1410 MB | 1410 MB |
| Version v2017 | 32 * (max server memory configuration) | 4 * (max server memory configuration) | |||
| Version v2016 | 32 * (max server memory configuration) | 4 * (max server memory configuration) | |||
| Version v2014 | Operating System Maximum | 128 GB | 64 GB | 1410 MB | |
| Version v2012 | Operating system maximum | 64 GB | 64 GB | 1 GB | 1 GB |
SQL Server Enterprise edition allows a maximum buffer pool extension size of 32 times the value of max_server_memory. SQL Server Standard edition allows a maximum buffer pool extension size of 4 times the value of max_server_memory
You can find more details about this version here
Back to all features