Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server taking 2 GB ram with out PAE Expand / Collapse
Author
Message
Posted Monday, January 28, 2013 2:41 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, July 21, 2014 4:10 AM
Points: 67, Visits: 255
Dear Gurus,

Can you please let me know why SQL server is taking more than 2 GB of RAM even PAE switch is not being added in boot.ini?

Following are the system credentials, on which this activity has been performed:

System RAM :8GB
OS :32bit
AWE :Checked
Maximum Server memory with in SQL Server :8GB
Maximum Ram consumption with PAE: 7.49GB
Maximum Ram consumption without PAE: 7.48GB

Thanks
Adeel Imtiaz
Post #1412277
Posted Monday, January 28, 2013 12:12 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, July 26, 2014 8:57 AM
Points: 7,081, Visits: 12,575
Having AWE enabled allows the system to address up to 4GB of RAM, the actual limit for a 32-bit system. 2GB is the artificial limit based on how Windows divides the 4GB of memory, 2GB each for kernel and user-mode processes.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1412596
Posted Friday, February 1, 2013 2:23 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:15 AM
Points: 6,182, Visits: 13,329
adeel.imtiaz (1/28/2013)
Dear Gurus,

Can you please let me know why SQL server is taking more than 2 GB of RAM even PAE switch is not being added in boot.ini?

Can post the list of options you are using in the boot.ini


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1414851
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse