Administrator’s tools in Microsoft SQL Server optimization for Microsoft Dynamics NAV

Marcin Woch


This article presents tools designed to help administrators and developers to optimize and monitor performances of SQL Server 2000 or SQL Server 2005 for Microsoft Dynamics NAV.


SQL Server 2000; SQL Server 2005; Microsoft Dynamics NAV; Navision Attain; SQL Server Profiler; Client Monitor; Session Monitor; Index Tuning Wizard; Database Tuning Advisor

Full Text:



Microsoft Business Solutions Navision 4.0 Course: E8404B Installation and Configuration Training. Microsoft Corporation 2004.

Dupont-Roc P., Gatchalian R., Serrano D.: Microsoft Dynamics NAV 4.0 Hardware Guide. 2006

Muhlbaher H.: Optimizing Dynamics NAV on SQL Server - Application. 2007.

Muhlbaher H.: Optimizing Dynamics NAV on SQL Server - Infrastructure. 2007.

Raheem M., Sonkm D., D’Hers T., LeMonds K.: Inside SQL Server 2005 Tools. Addison Wesley Professional. Boston 2006

Woody B Administrator's Guide to SQL Server 2005 Addison Wesley Professional, Boston 2006

Rankins R., Jensen P., Bertucci P.: Microsoft SQL Server 2000. Księga eksperta. Helion, Glmice 2003.

Bieniek D., Dyess R., Hotek M., Loria J., Machanic A., Soto A., Wiernik A.: Microsoft SQL Server 2005 Implementation and Maintenance, Self Paced Training Kit. MSPress, Redmont 2006.

Nielsen P.: SQL Server 2005 Bible. Wiley Publishing. Inc.. Indianapolis 2007.

Thomas O., McLean I.: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 Microsoft Press, Redmont 2006

Microsoft Dynamics NAV 5.00 Application Designer’s Guide. Microsoft Corporation, Redmont 2007.

Woch M.: MS SQL Server Optimization for MS Dynamics NAV. ZN Pol. Śl. Studia Informatica Vol. 28. No. 2 (71). Gliwice 2007.

Mcrosoft Business Solutions - Navision SQL Server Option Resource Kit. 2004.

Mcrosoft Business Solutions - Navision Application Benchmark Tool 1.00. 2004.