awe enable?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » awe enable?

awe enable?

Rate Topic

Display Mode

Topic Options

Author

Message

Zeal-DBA

Posted Wednesday, December 19, 2012 4:23 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:11 AM
Points: 185, Visits: 941

hello experts,

please go through my server configuration

windows server 2003 enterprise sdition 32 bit
sql server 2005 enterprise edition 32 bit
/pae enabled
Total RAM 64 GB (i confused in this configuration it dosn't support more than 32 GB RAM please advise)

should i require to enable awe
should i require to set max server memory (if yes please tell the value?)
should i require to set min server memory (if yes please tell the value?)

please help its urgent
thanks

Post #1398294

anthony.green

Posted Wednesday, December 19, 2012 4:46 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

Server 2003 32bit Enterprise RAM limit = 32GB

Min Max memory should be set to something reasonable, is this a dedicated server just for SQL or will other apps be running on it?

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1398308

Zeal-DBA

Posted Wednesday, December 19, 2012 4:47 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:11 AM
Points: 185, Visits: 941

its a dedicated server

Post #1398310

anthony.green

Posted Wednesday, December 19, 2012 4:58 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

Set Max memory at 26GB or there abouts, leaves enough for the OS to manage itself OK.

If its dedicated I wouldnt worry about min memory so much as only SQL and the OS are using RAM so its not like anything else will be wanting the resources, but you could set it at a value if you wanted to.

And yes I would enable AWE and also give the service account lock pages in memory rights

Post #1398319

Zeal-DBA

Posted Wednesday, December 19, 2012 7:30 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:11 AM
Points: 185, Visits: 941

anthony,
in windows server 2003 Lock pages memory default assigned to Administrator group and option for adding new user is disabled. i guess SQL account user need to add in administrator group right?

Post #1398409

anthony.green

Posted Wednesday, December 19, 2012 7:42 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

Configure it by changing Group Policy, ask your AD guys to put all your SQL servers into an OU then assign a GPO to that OU so that accounts can be set to have the LPIM right and it will only take presidence over that OU.

Post #1398417

« Prev Topic | Next Topic »

Permissions