The Nav/SQL Performance Field Guide
"The NAV/SQL Performance Field Guide" is a booklet for the experienced NAV/SQL administrator which explains in a simple and easily understandable way the known (and unknown?) performance problems encountering with Microsoft Dynamics NAV (Navision) and Microsoft SQL Server and gives practical advices, solutions and recommendations to fix and avoid problems; covering all major areas of performance optimization and troubleshooting: + Performance Measurement & Analysis + Platform Sizing & Configuration + SQL Server Configuration + Database Setup + Index- and SIFT/VSIFT Tuning + Block- and Deadlock Detection + Query Analysis + C/AL Code Optimization + and much more! Applies to Navision Financials 2.60/2.65 Navision Attain 3.01/3.60/3.70 Microsoft Business Solutions Navision 4.00 Microsoft Dynamics NAV 5.00 Microsoft Dynamics NAV 5.00 SP1 Microsoft Dynamics NAV 2009 Microsoft Dynamics NAV 2009 SP1/R2 Microsoft Dynamics NAV 2013/R2 with Microsoft SQL Server 2000 Microsoft SQL Server 2005 Microsoft SQL Server 2008/R2 Microsoft SQL Server 2012