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

Microsoft Dynamics NAV Database Optimization Steps

Microsoft Dynamics NAV Database Optimization Steps


MAINTENANCE PLAN

Use SQL Server "Maintenance Plans" to manage NAV database optimization

- Create a plan to degrafment indexes (ex. every night) > Microsoft Script

look at my blog "MSDN Microsoft Script"

blogs.dotnethell.it/.../Defragment-All-Indexes-In-A-Database-Microsoft-Script__16778.aspx

- After recalculate statistics

- Create a plan to rebuild the indexes at least once a week (if you have time also each night instead of degrament)

- Rebuilding the index removes fragmentation inside the database and at the same time calculates the statistics

- Do NOT use autoshrink in properties or with a maintenance plan


PERFORMANCE TUNING STEPS

- Crete more datafiles on filegroup

After create a Reorganize job to move table on different datafiles (will reduce locks &  disk I/O)

Microsoft Best Practices for NAV Performances

Optimizing SQL Server Performance with Microsoft Dynamics NAV

msdn.microsoft.com/.../hh169233(v=nav.71).aspx

---------------------------------------------------------------------------

Roberto Stefanetti,  Dynamics Community Moderator

My Blog http://blogs.dotnethell.it/DynamicsNAV 

Twitter @robstefane


Level 3   Microsoft Dynamics NAV Community Contributor   Community Moderator for Microsoft Dynamics NAV                                           
Categoria: Community & Forums
giovedì, 10 lug 2014 Ore. 14.39
Statistiche
  • Views Home Page: 399.829
  • Views Posts: 820.195
  • Views Gallerie: 0
  • n° Posts: 345
  • n° Commenti: 0
Copyright © 2002-2007 - Blogs 2.0
dotNetHell.it | Home Page Blogs
ASP.NET 2.0 Windows 2003