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