Previous Windows Memory Rights SQL Server AWE Property Next

SQL Server Memory Startup Switches

This section describes the SQL Server Startup switches that affect SQL Server memory management.

This section covers the following items:
g Switch
T845 Switch
Recommendations for SQL Server Startup Switches

A number of other SQL Server Startup Switches exist that are not relevant for SQL Server memory management.

g Switch

This switch controls the amount of memory that is bypassed by SQL Server at the bottom of the Windows memory range. The g Switch is only useful in 32-bit systems.

The g Switch is normally only needed when SQL Server ues more than 12GB memory on a 32-bit system. It is not needed on a 64-bit system.

SQL Server Books Online has a good descripton of when the g Switch may be of use.

SQL FineBuild does not automatically set the g Switch, but it may be included in a FineBuild install by adding the following parameter:
/TF5:g640

Top

T845 Switch

This switch allows SQL Server Standard Edition to make use of the Windows Lock Pages in Memory right. See Windows Memory Rights for more details.

SQL FineBuild will automatically apply the T845 Switch when installing SQL Server.
Top

Recommendations for SQL Server Startup Switches

The recommended settings for the Operating System Switches described on this page are given below:

The g Switch should only be used in the situations described in Books Online
The T845 Switch should always be present when using Standard Edition
Copyright © 2013 Edward Vassie. License and Acknowledgements
Previous Windows Memory Rights Top SQL Server AWE Property Next

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