MSSQLSERVER_17179
Details
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. |
Explanation
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.
User Action
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).