Switches in sql Server

Published on September 27 2015 by LakshmiSaahul,Dhana Royal

/3GB Switch:
___________________
By default SQL Server can be able to utilize 2 GB max meO\Smory in 32-bit o/s.
If required to use SQL Server more than 2 GB then recomnded to enable /3GB swtch in BOOT.INI file.
Note pad will be opened and at last enable /3GB and save the notepad file. After your SQL Server can be able to consume 3 GB max.
PAE [Physical addressing extension] :
___________________________________

Enable /PAE switch in OS level and

If RAM<3GB:
/3GB

If RAM > 4GB and <16GB
PAE

AWE[ Adessing windowing extension]:
____________________________________
enable AWE option in SQL Server level.

Note: As there is a risk involved with memory consumption from OS Mode, it is always recommended
to set "MAX SERVER MEMORY" restriction.

Note: In 64-bit O/S no need to enable any swithces to use memory by SQL Server applications.

Advertising