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, April 07, 2014 5:48 AM
Points: 66, Visits: 251
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: Wednesday, April 16, 2014 9:25 AM
Points: 7,070, Visits: 12,523
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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
Post #1412596
Posted Friday, February 01, 2013 2:23 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:04 AM
Points: 5,970, Visits: 12,865
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