RS First Dynamics NAV Blog


...from NAV 3.60 to NAV 2013
Archivio Posts
Anno 2015

Anno 2014

Anno 2013

Anno 2012

Anno 2011

Anno 2010

Anno 2009

Anno 2008

Anno 2007

Lock Page in Memory policy (for Enabling AWE)

Make sure that the user account the SQL Server service is running
on is added to "Lock Page in Memory policy" of the "User Rights
Assignments" in "Local Security Policy" of the computer.

"Lock Page in Memory policy"  --> Assigning policy

a) Click on Start and choose Programs
b) Choose Administrative Tools, and then select Local
Security Policy.
c) Expand Security Settings
d) Expand Local Policies, and then click User Rights
Assignments.
e) From the screen on the right, right-click Lock pages
in memory,
and then click Security.
f) In the Local Security Policy Setting dialog box, click
Add.
g) Click to select the account where the MSSQLSERVER
service is running.
h) Click OK.
i) Restart the SQL Server service.

Enable AWE

k) Start SQL Query Analyzer
l) Use Master from the drop-down list box of database
m) sp_configure 'show advanced options', 1 and press F5
(function key F5)
n) RECONFIGURE and press F5 (function key F5)
o) sp_configure 'awe enabled', 1
p) RECONFIGURE and press F5 (function key F5)
r) Stop and Re-start all SQL Services (SQLServer,
SQLAgent)

Note: Since AWE is a dynamic API, the changes will take place only after
the services are re-started.

11) Make sure the "Working size" is set to 0. If this is not set to 0,
following these commands in SQL Query Analyzer

a) sp_configure 'set working size', 0 and press F5
(function key F5)
b) RECONFIGURE and press F5 (function key F5)

Categoria: Sql Server ALL
venerdì, 07 mar 2008 Ore. 16.04

Messaggi collegati


Statistiche
  • Views Home Page: 468.801
  • Views Posts: 885.614
  • Views Gallerie: 0
  • n° Posts: 343
  • n° Commenti: 0
Copyright © 2002-2007 - Blogs 2.0
dotNetHell.it | Home Page Blogs
ASP.NET 2.0 Windows 2003