This project has moved. For the latest updates, please go here.

Previous Windows Memory Switches SQL Server Memory Startup Switches Next

Windows Memory Rights

This section describes the Windows Rights that affect SQL Server memory management.

This section covers the following items:
Lock Pages in Memory Right
Recommendations for Windows Memory Rights

A number of other Windows Rights exist that are not relevant for SQL Server memory management.

Lock Pages in Memory Right

The Lock Pages in Memory Right will let Windows honour an API call from a program to reserve a range of memory for its exclusive use.

If Windows runs short of memory, it uses something like the following multi-stage process to reclaim memory from programs. If enough memory is reclaimed at the end of a given stage, the following stages are not processed.

1) Non-essential program and Windows memory is moved to the Windows Page File
2) Programs with locked memory are asked to release it
3) Locked memory is reclaimed by Windows
4) In-use program memory is reclaimed by Windows
5) Private Work Set memory is reclaimed by Windows
6) Snap Dump and Reboot process starts

When memory is reclaimed by Windows, this can severely slow down or even stop the affected program from processing. It is therefore important to avoid over-committing memory, so that the performance of SQL Server is not put at risk by memory stortages.

Top

Recommendations for Windows Memory Rights

The recommended settings for the Windows Memory Rights described on this page are given below:

The Lock Pages in Memory Right should always be granted to the account running the SQL Server database engine. SQL FineBuild will always grant this right.
Copyright © 2013 Edward Vassie. License and Acknowledgements
Previous Windows Memory Switches Top SQL Server Memory Startup Switches Next

Last edited Mar 27, 2013 at 5:40 PM by EdVassie, version 1