Roberto Stefanetti NAV Blog


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

Anno 2015

Anno 2014

Anno 2013

Anno 2012

Anno 2011

Anno 2010

Anno 2009

Anno 2008

Anno 2007

Errore Sql: SQL Server has encountered 1 occurrence(s) of IO

Errore Sql : SQL Server has encountered 1 occurrence(s) of IO Causa jobs, Backup, Index defrag, or DTS package schedulate --> Soluzione : forzare una compattazione del log file Compattazione del log file es: DBCC SHRINKFILE(pubs_log, 20)BACKUP LOG pubs WITH TRUNCATE_ONLYDBCC SHRINKFILE(pubs_log,20) 
Leggi tutto il post...
Categoria: Sql Server ALL
giovedì, 13 mar 2008 Ore. 17.02

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 on 
Leggi tutto il post...
Categoria: Sql Server ALL
lunedì, 10 mar 2008 Ore. 16.25

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 RightsAssignments" in "Local Security Policy" of the computer. "Lock Page in Memory policy"  --> Assigning policy a) Click on Start and choose Programsb) Choose Administrative Tools, and then select LocalSecurity Policy.c) Expand Security Settingsd) Expand Local Policies, and then click User RightsAssignments.e) From the screen on the right, right-click Lock pagesi 
Leggi tutto il post...
Categoria: Sql Server ALL
venerdì, 07 mar 2008 Ore. 16.04
DYNAMICS NAV MVP 2016



FOLLOW ME! ON SOCIALS

Statistiche
  • Views Home Page: 264.044
  • Views Posts: 580.438
  • Views Gallerie: 661
  • n° Posts: 347
  • n° Commenti: 26
Mappa
Meteo
Copyright © 2002-2007 - Blogs 2.0
dotNetHell.it | Home Page Blogs
ASP.NET 2.0 Windows 2003