The NAV/SQL Performance Field Guide

Fixing Trouble with Microsoft Dynamics NAV and Microsoft SQL Server

von

“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