measure PAE using or not?

Question

measure PAE using or not?

SQL Galaxy

One Orange Chip

Points: 29472
More actions
May 22, 2012 at 6:54 am

#258518

OS - Win 2003 Enterprise Edition
Database - SQL 2008 Enterprise Edition
Memory - 4GB
please tell me, how to measure /PAE really using or not after configured as below boot.ini file.
boot loader]
timeout=5
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /noexecute=optout /fastdetect /PAE
Thanks
ananda

Viewing 8 posts - 1 through 7 (of 7 total)

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

Divine Flame SSCoach Points: 15943 More actions · Answer 1

ananda.murugesan (5/22/2012)
OS - Win 2003 Enterprise Edition
Database - SQL 2008 Enterprise Edition
Memory - 4GB
please tell me, how to measure /PAE really using or not after configured as below boot.ini file.
boot loader]
timeout=5
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /noexecute=optout /fastdetect /PAE
Thanks
ananda

Have you increased the amount of memory assigned to SQL Server? I don't see the /3GB switch here in boot.ini configuration.

Sujeet Singh

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

32 bit OS and SQL?

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 3

ananda.murugesan (5/22/2012)
OS - Win 2003 Enterprise Edition
Database - SQL 2008 Enterprise Edition
Memory - 4GB
please tell me, how to measure /PAE really using or not after configured as below boot.ini file.
boot loader]
timeout=5
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /noexecute=optout /fastdetect /PAE
Thanks
ananda

Ok, let's start with the obvious. You only have 4GB RAM but you expect to use Physical Address Extensions which is designed to address memory allocations above 4GB (you at least have the Enterprise edition of Windows 2003)!

Also, specifying /PAE when you have DEP turned on with /noexecute=optout is pointless as the DEP option automatically implies PAE 😉

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

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

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

Thanks for all yours reply..

Operating system & SQL 2008 32 bit processor architicture.

Please confirm the options which is correct boot.ini file modification.

Option -1

boot loader]

timeout=5

default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /noexecute=optout /fastdetect /PAE

Option -2

boot loader]

timeout=5

default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /fastdetect /3GB

Option -3

boot loader]

timeout=5

default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /fastdetect /3GB /USERVA=3030

thanks

ananda

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

For this scenario - 4GB memory, option 2.

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 6

ananda.murugesan (5/23/2012)
Please confirm the options which is correct boot.ini file modification.
Option -2
boot loader]
timeout=5
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /fastdetect /3GB

Option 2 initially, but bear in mind that not specifying /noexecute=optout will automatically optin. If you had DEP enabled for certain prcesses its now turned off for all processes and only active for windows system processes\components

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

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

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

Thanks for reply

Option 2, Modified the boot.ini file as below

[boot loader]

timeout=5

default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /noexecute=optout /fastdetect /3GB

Thanks

ananda