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: 2 days ago @ 4:08 AM
Points: 71, Visits: 270
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: Yesterday @ 8:12 AM
Points: 7,135, Visits: 12,746
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 @ 2:38 PM
Points: 6,635, Visits: 14,218
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