SQL Server 2012 and later versions of standard editionS also recognize Hot Add memory when running in a virtual environment. SQL Server versions that do not support Hot Add Memory are still supported. But these versions will detect only the memory that is present in the operating system when SQL Server starts.. GeoPITS brings you the comprehensive details of Hot add memory and CPU's support in different versions & editions of SQL Server.
| Version | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Version v2019 | Yes | ||||
| Version v2017 | Yes | ||||
| Version v2016 | Yes | ||||
| Version v2014 | Yes | ||||
| Version v2012 |
SQL Server 2012 and later versions of standard editionS also recognize Hot Add memory when running in a virtual environment. SQL Server versions that do not support Hot Add Memory are still supported. But these versions will detect only the memory that is present in the operating system when SQL Server starts.
You can find more details about this version here
Back to all features