InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 16:05:24 GMT20http://www.sqlservercentral.com/Forums/Topic1398294-360-1.aspxConfigure 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.Wed, 19 Dec 2012 07:42:27 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1398294-360-1.aspxanthony,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?Wed, 19 Dec 2012 07:30:34 GMTZeal-DBAhttp://www.sqlservercentral.com/Forums/Topic1398294-360-1.aspxSet 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 rightsWed, 19 Dec 2012 04:58:20 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1398294-360-1.aspxits a dedicated serverWed, 19 Dec 2012 04:47:58 GMTZeal-DBAhttp://www.sqlservercentral.com/Forums/Topic1398294-360-1.aspxServer 2003 32bit Enterprise RAM limit = 32GBMin Max memory should be set to something reasonable, is this a dedicated server just for SQL or will other apps be running on it?Wed, 19 Dec 2012 04:46:35 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1398294-360-1.aspxhello experts,please go through my server configuration windows server 2003 enterprise sdition 32 bit sql server 2005 enterprise edition 32 bit /pae enabledTotal RAM 64 GB (i confused in this configuration it dosn't support more than 32 GB RAM please advise)should i require to enable aweshould 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 urgentthanksWed, 19 Dec 2012 04:23:37 GMTZeal-DBA