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

How to Set Minimum and Maximum memory in AWE SQL2005 Expand / Collapse
Author
Message
Posted Tuesday, October 9, 2012 4:16 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 4, 2014 11:57 PM
Points: 67, Visits: 256
Dear All,

I have 16 GB server physical ram windows 2003 EE 32 Bit.

I want to enable AWE with :-

Minimum 7000 MB means 7 Gb
Maximum 11000 MB means 11 GB

but when i run. dbcc memorystatus
it shows me old values.

Please help me in this regard. I will be obliged.

Please find attached screenshot.

Thanks
Malik Adeel Imtiaz


  Post Attachments 
sql MEMORY ISSUE.JPG (9 views, 105.54 KB)
Post #1370286
Posted Tuesday, October 9, 2012 5:25 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:02 AM
Points: 39,866, Visits: 36,207
Setting AWE on requires a service restart to take effect.


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 #1370327
Posted Tuesday, October 9, 2012 5:42 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 4, 2014 11:57 PM
Points: 67, Visits: 256
I already restarted the services and complete server restart .

But still no results.
Post #1370338
Posted Tuesday, October 9, 2012 5:56 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:02 AM
Points: 39,866, Visits: 36,207
Is the PAE switch present in boot.ini? (or is it a 64-bit OS?)


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 #1370341
Posted Tuesday, October 9, 2012 6:11 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 4, 2014 11:57 PM
Points: 67, Visits: 256
Windows 2003 32 Bit Enterprise Edition.

PAE switch is enabled.
Post #1370352
Posted Tuesday, October 9, 2012 6:26 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 4, 2014 11:57 PM
Points: 67, Visits: 256
I have resolved the problem.....


I have added /3g switch with / PAE and restart the server. and problem has been resolved.

Thank you so much for your support.


Thanks
Malik Adeel Imtiaz

Post #1370362
Posted Tuesday, October 9, 2012 10:58 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 4, 2014 11:57 PM
Points: 67, Visits: 256
Dear Gila Monster,

Thank you so much for your great support and time.


Thanks
Malik Adeel Imtiaz
Post #1370672
Posted Wednesday, October 10, 2012 1:05 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:02 AM
Points: 39,866, Visits: 36,207
If you have 16 GB of memory, you do not want the /3GB switch enabled, it can be harmful. I suggest you remove that switch. You just need the /PAE and AWE enabled within SQL Server.


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 #1370720
Posted Wednesday, October 10, 2012 1:43 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 4, 2014 11:57 PM
Points: 67, Visits: 256
Actually first we have tried with out /3g switch and without /3g switch that we have noticed that AWE memory did not cross 2 GB memory.

After that we have enabled /3g switch and AWE memory crosses 5 GB.

Please see attachment.





  Post Attachments 
AWE_settings.docx (16 views, 439.13 KB)
Post #1370741
Posted Wednesday, October 10, 2012 2:22 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:02 AM
Points: 39,866, Visits: 36,207
Again, you do not need /3gb for memory usage above 4GB. That's the /PAE switch and the AWE settings alone. With 16 GB memory, /3GB can be harmful as it reduces the number of page table entries you have and can result in memory issues for the OS.

Chapter 4: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/



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 #1370757
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse