SQL 2012 Memory Tip #1 - No AWE in SQL 2012

published: 2012-09-11 00:00

AWE memory management no longer exists in SQL 2012. This might be something to take into consideration if clients are still running 32-Bit SQL and planning to upgrade SQL. As it could mean the total memory used via SQL would be less, therefore affecting performance.

In SQL Server 2012, the maximum amount of memory that can be used by the 32-bit instance of SQL Server is determined as follows.

SQL Server and operating system settings Maximum amount of memory used by SQL Server

32-bit SQL Server on 32-bit OS 2 GB
32-bit SQL Server on 32-bit OS with /3G boot option 3 GB
32-bit SQL Server on 64-bit OS 4 GB
Robert Wylie
Robert is a senior DBA in the RockSolid SQL DBAaaS team providing support, advice and project delivery for all areas of SQL Server. Robert has been part of the RockSolid SQL team since 2005.

RockSolid Automation Platform