awe Archives - SQLChamp

Memory Configuration Changes | SQL Server 2012

March 3, 2016 Sarabpreet Singh Anand awe, lock pages in memory, max server memory, memory, memory to reserve, min server memory, multi page allocation, Single page allocation, SQL 2012, SQL Server Denali, SQLServer

Hi Friends, There are a few changes in SQL Server 2012 in Memory Manger, and a DBA should be aware

Memory Shortage for all 32 Bit SQL Server 2012 Instances

February 18, 2016 Sarabpreet Singh Anand 32 Bit SQL Server 2012 Instances, 32-bit, 64-bit, awe, awe enabled, Memory Shortage, PAE, SQL Denali, SQL2012, x86

Hi Friends, As you all know AWE has been deprecated and not available from SQL Server 2012 (Find details here),

SQL Server AWE Enabled Option | Deprecated

February 16, 2016 Sarabpreet Singh Anand awe, awe enabled, Denali, deprecated, SQL 2012, SQLServer 2012

Like we already know, Windows-based applications can use Windows AWE (Address Windowing Extensions) APIs to allocate and to map physical