• I expect based on your response that my post was not clear. Thanks for the reply regardless.

    I have not set Locked Pages for this server, yet it is reporting locked pages anyway.

    I was not viewing memory reported for sqlserver.exe right after a reboot. Normal operation has the task manager report that process as using about 500 MB.

    For example, right now:

    I have the sql server max memory set at 28000 MB.

    Currently sqlserver.exe reports using 593,000 KB

    When I query sys.dm_os_memory_nodes, I show locked_page_allocations_kb = 28352836 (so all of the memory I allow for SQL).

    My confusion here is that I do not have anything specified in the Local Group Policy for "Lock Pages in Memory". The article I referenced in m OP, and everything else I find, seems to indicate that this is Local Security Policy is the only way to turn on Locked Pages in SQL 2012. I have not done that, yet my server reports locked_page_allocation_kb.

    Others I talk to with similar setups have their task manager reporting the full amount of sql server memory showing on the sqlserver.exe process, and 0 in locked_page_allocations_kb.