How to install microsoft sql server 2012 enterprise edition

#How to install microsoft sql server 2012 enterprise edition windows#

In SQL Server 2012, you can enable 'locked pages' by granting the 'lock pages in memory' user right for the startup account for the instance of SQL Server in Windows. Starting with SQL Server 2012, the memory manager simplifies the usage of 'locked pages' across supported editions and processor architectures. SQL Server 32-bit versions 2005, 2008, and 2008 R2 use 'locked pages' when the 'awe enabled' SQL Server feature is enabled. The behavior is different, depending on the edition of SQL Server in these versions.

#How to install microsoft sql server 2012 enterprise edition windows#

The use of AWE APIs for memory management in 64-bit SQL Server is also frequently referred as 'locked pages.' You can enable the 'locked pages' feature in SQL Server versions 2005, 2008, and 2008 R2 by using a combination of Windows user right, hotfix, and trace flags. The SQL Server 64-bit version uses 'locked pages' to prevent the process working set (committed memory) from being paged out or trimmed by the operating system. The application requires the 'Lock Pages In Memory' user right (LPIM) to be granted for the application to be able to lock pages in memory. Memory that is allocated by using this method is never paged out by the operating system and is locked down until the application explicitly frees it or exits.

Windows-based applications can use Windows AWE ( Address Windowing Extensions) APIs to allocate and to map physical memory into the process address space.