3GB PAE in windows 2008 32 bit?

Question

Post reply

3GB PAE in windows 2008 32 bit?

SQL Galaxy

One Orange Chip

Points: 29472
More actions
January 24, 2012 at 11:42 pm

#391396

Hi,
Total Physical Ram - 4GB
Operating system - Windows server 2008 Enterprise edition 32 bit.
Database - SQL Server 2008 Enterprise edition with SP3
currently SQL server 2008 memory configured as below
1. 'min memory per query (KB)', N'2048'
2. 'max server memory (MB)', N'2559'
3. 'min server memory (MB)', N'1024'
Now server is running normal and default configuration in operating system. if I am going to implement & enable 3GB Switch in PAE (physical Address Extension) to SQL Server 2008, which & when circumstance should be enable this advance option at operating system in windows 2008 32 bit.
Thanks
ananda

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

umasingh Ten Centuries Points: 1182 More actions · Answer 1

Check this post.

http://serverfault.com/questions/57773/is-using-the-3gb-statup-switch-in-windows-2008-x86-only-running-sql-server-2008

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

With that memory config (4GB only), /3GB yes (lets SQL use 3 out of the 4 GB instead of 2), but not PAE. PAE is for AWE memory, that's more useful if you have more than 4GB memory.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 3

GilaMonster (1/25/2012)
With that memory config (4GB only), /3GB yes (lets SQL use 3 out of the 4 GB instead of 2), but not PAE. PAE is for AWE memory, that's more useful if you have more than 4GB memory.

Thanks Gail for your replay...

I cleared my doubts..

4GB only can enbale /3GB switch in windows 2008 32 bit OS.

should I use this command for enable /3GB?

> BCDEdit /set IncreasedUserVA 3072

Does SQL Service need to restart ?

sp_configure anything changes reauired after run that command?

Thanks

ananda

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Well, you need to restart the entire server for a boot.ini flag to take effect, so restarting SQL is implied

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 5

One more doubts?

PAE and AWE fully deprecated these advance memory option in 64 bit system.

If I have 32 GB RAM, Can I have add /3GB boot.ini file windows 2008 R2 64 bit OS?

thanks

ananda

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

PAE and 3GB are totally and completely unnecessary with a 64-bit OS.

p.s. On a 32-bit server you wouldn't use 3GB if you had over 4GB of memory. You'd use PAE instead.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 7

SQL Galaxy

One Orange Chip

Points: 29472

January 28, 2012 at 4:20 am

#1439665

Thank you so much:-)

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 8

By using the /3GB or /USERVA startup switches in the Windows boot.ini file, this default configuration can be overridden to provide 3GB of VAS to the user address space application like SQL SERVER etc..

leaving 1GB for the kernel address space and using operating system etc..

Server is running dedicated by SQL SERVER 2008 32 bit. also running other application symantec Endpoint Protection, it is scanning on weekly one time basis, and daily basis LTO Backup running on night time. could you confirm 1GB memory sufficient for running those application and windows 2008 OS?

thanks

ananda

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 9

The 1GB is the kernal's VAS allocation, not the free memory used by other apps.

If you need more free memory for other apps, lower SQL's max server memory.

Chapter 4 - http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Perry Whittle SSC Guru Points: 234013 More actions · Answer 10

ananda.murugesan (2/4/2012)
also running other application symantec Endpoint Protection, it is scanning on weekly one time basis, and daily basis LTO Backup running on night time. could you confirm 1GB memory sufficient for running those application and windows 2008 OS?

You would need to consult with Symantec to verify their applications compatability with that configuration 😉

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉