“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 Setup & 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
with
• Microsoft® SQL Server™ 2000
• Microsoft® SQL Server™ 2005
• Microsoft® SQL Server™ 2008