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 12»»

Min and Max server memory Expand / Collapse
Author
Message
Posted Wednesday, April 17, 2013 2:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 23, 2014 2:59 AM
Points: 4, Visits: 106
Am a junior DBA and We have an issue from last couple of days. We have a server of Windows 2003 Standard Edtion of x64 bit with SP2. SQL Server is of 32bit running. Physical Memory on the server is 0f 4GB and SQL now running out of memory. Can we enable the AWE on a 64 bit OS machine where SQL is of 32 bit

Please suggest me
Post #1443484
Posted Wednesday, April 17, 2013 2:24 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:58 PM
Points: 5,888, Visits: 13,063
you can but its of minimal use to you with a physical limitation of 4GB on the server.

what makes you think you are running out of memory?

How much memory is SQL using currently and have you enabled the /3GB switch in the boot.ini file?


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

Post #1443489
Posted Wednesday, April 17, 2013 2:47 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:22 AM
Points: 40,632, Visits: 37,094
With only 4 GB, I'd recommend adding the /3GB flag to boot.ini, not /PAE and not enabling AWE. When/if you add more memory to go over 4GB, then AWE is useful


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1443497
Posted Wednesday, April 17, 2013 3:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 23, 2014 2:59 AM
Points: 4, Visits: 106
Is reboot of the server required after adding /3gb in the boot.ini file?SQL is consuming 2.3GB of memory
Post #1443510
Posted Wednesday, April 17, 2013 3:32 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 23, 2014 2:59 AM
Points: 4, Visits: 106
I could see PAE is enabled in the boot.ini file as this is the 64 bit machine. Can you please suggest me removing of the PAE from boot.ini and adding /3gb is fine?
Post #1443512
Posted Wednesday, April 17, 2013 4:02 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:58 PM
Points: 5,888, Visits: 13,063
prashanthreddymr (4/17/2013)
Is reboot of the server required after adding /3gb in the boot.ini file?SQL is consuming 2.3GB of memory


yes a reboot is required.

Where did you get the 2.3GB reading from, that suggests the 3GB switch is already enabled otherwise I would expect the reading to be about 1.7GB.


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

Post #1443526
Posted Wednesday, April 17, 2013 4:03 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:58 PM
Points: 5,888, Visits: 13,063
prashanthreddymr (4/17/2013)
I could see PAE is enabled in the boot.ini file as this is the 64 bit machine. Can you please suggest me removing of the PAE from boot.ini and adding /3gb is fine?


yes its fine


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

Post #1443527
Posted Wednesday, April 17, 2013 4:08 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 23, 2014 2:59 AM
Points: 4, Visits: 106
I got it from the Mem Usage in the windows task manager where sqlserver.exe is consuming this 2,593,424K
Post #1443530
Posted Wednesday, April 17, 2013 11:08 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 31, 2014 7:48 PM
Points: 119, Visits: 494
If SQL is consuming 2.3 GB, and if you see /3G switch already enabled, why you want to remove ?

If you have 4 GB of RAM, I would go setting SQL Max memory to 3200 MB (I believe its recommended) and the leave rest for OS.

Hope this helps..


Cheers,
- Win
"Dont Judge a Book by its Cover"
Post #1443596
Posted Wednesday, April 17, 2013 11:54 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:22 AM
Points: 40,632, Visits: 37,094
prashanthreddymr (4/17/2013)
I could see PAE is enabled in the boot.ini file as this is the 64 bit machine. Can you please suggest me removing of the PAE from boot.ini and adding /3gb is fine?


If it's a 64-bit OS then /3GB is not needed (nor is /PAE), just set SQL's max server memory to 3 GB.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1443608
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse