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

memory Expand / Collapse
Author
Message
Posted Thursday, November 8, 2012 12:38 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
To enable AWE and configure Lock Pages do we have to restart server or SQL service.

any views.



Regards
Durai Nagarajan
Post #1382294
Posted Thursday, November 8, 2012 12:53 AM


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 @ 5:25 AM
Points: 43,024, Visits: 36,185
AWE no. Locked pages, requires a service restart. If the /PAE switch is not in boot.ini already, that requires a reboot.

32-bit only, on 64 neither PAE nor AWE is relevant.



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 #1382302
Posted Thursday, November 8, 2012 12:56 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
It is a 32 bit system, thanks for your input gail.



Regards
Durai Nagarajan
Post #1382303
Posted Thursday, November 8, 2012 12:58 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 1, 2013 10:17 AM
Points: 323, Visits: 984
GilaMonster (11/8/2012)
AWE no. Locked pages, requires a service restart


Hi Gail,
But MS specify in Books online that

To make AWE available to an instance of SQL Server, use sp_configure to set the awe enabled option to 1, and then restart SQL Server.

http://technet.microsoft.com/en-us/library/ms190673%28v=sql.105%29.aspx


-----------------------------------------------------------------------------
संकेत कोकणे
Post #1382305
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse