Help with /3GB /PAE

Question

Post reply

Help with /3GB /PAE

Rachell-76794

Ten Centuries

Points: 1067
More actions
December 19, 2003 at 6:21 am

#66234

We have new cluster server and total 8GB and have /3GB /PAE on boot.ini file, and awe enabled also, but server only see 2.6GB memory, we move all db from old server to this box, and even old box can see more memory close 6GB, any one know why? Or something else need configure on window 2000 advanced server?
Thanks
feifei liu

Rachel

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

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

Jonathan SSC-Insane Points: 20427 More actions · Answer 1

You probably haven't given the service account the right to lock pages in memory. Check the local policy.

--Jonathan

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 2

Yes, the service account SQL Server runs under needs to have this privilege as Jonathan indicates. Also ensure you've configured SQL Server to be able to use AWE memory:

sp_configure 'show advanced options', 1

RECONFIGURE

GO

sp_configure 'awe enabled', 1

RECONFIGURE

GO

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

K. Brian Kelley
@kbriankelley

Rachell-76794 Ten Centuries Points: 1067 More actions · Answer 3

Rachell-76794

Ten Centuries

Points: 1067

December 19, 2003 at 7:56 am

#487210

Thanks, That is our problem

feifei liu

Rachel

Rachell-76794 Ten Centuries Points: 1067 More actions · Answer 4

But do we need /3GB in the .ini file for window 2000 advanced server?

Thanks

feifei liu

Rachel

Jonathan SSC-Insane Points: 20427 More actions · Answer 5

quote:
But do we need /3GB in the .ini file for window 2000 advanced server?
Thanks
feifei liu

You don't need it, but it will improve performance.