Export (0) Print
Expand All
Expand Minimize

MSSQLSERVER_17179

Product Name

SQL Server

Product Version

10.0

Product Build Number

10.00.0000.00

Event ID

17179

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

INIT_AWE_NOT_ENABLED

Message Text

Could not use Address Windowing Extensions because the 'lock pages in memory' privilege was not granted.

The Windows Lock Pages in Memory privilege is disabled by default. This privilege must be enabled to configure Address Windowing Extensions (AWE). It determines which accounts can use a process to keep data in physical memory, preventing the system from paging the data to virtual memory on disk. On 32-bit operating systems, enabling this privilege when not using AWE can significantly impair system performance. Locking pages in memory is not required on 64-bit operating systems.

If you have system administrator permissions, use the Windows Group Policy tool (gpedit.msc) and grant this privilege to the account that SQL Server is running. For more information about how to enable Lock Pages in Memory, see How to: Enable the Lock Pages in Memory Option (Windows).

Community Additions

ADD
Show:
© 2014 Microsoft