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

SQL Memory Tips: steps to use full Sql 2005 memory

To use more than 4GB: 

SQL 2005 32 Bit
1. Add /PAE to boot.ini

2. Configure lock pages in memory, in group policy , computer configuration
expand window settings, expand security settting, local policies, user right assignments,
click lock pages in memory , add sql account that starts up sql.

3 In sql 2005 memory settings tick flag use AWE.

In error log see SET AWE enabled to 1 in configuration parameter to allow use of more memory.
(Do not see anything in lock pages in memory and only have 4GB so not sure
if message should be coming out).

SQL 2005 64 Bit
1. No ini files to set

2. configure lock pages in memory, in group policy , computer configuration expand window settings,
expand security settting, local policies, user right assignments, click lock pages in memory , add
sql account that starts up sql

3. Do not set the awe flag in sql.
Error Log see message "lock page in memory" not sure of exact message not got 64 bit machine yet.

Categoria: Sql Server ALL
lunedì, 10 mar 2008 Ore. 16.25

Messaggi collegati


Statistiche
  • Views Home Page: 470.402
  • Views Posts: 887.334
  • 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