Magic 7
Field Guide
Performance Quick-Check
Impressum & Datenschutz
© 2006-2023, Jörg A. Stryk
Der 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 Setup & Configuration
  • SQL Server Configuration
  • Database Setup
  • Index- and SIFT/VSIFT Tuning
  • Block- and Deadlock Detection
  • 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
  • Microsoft® Dynamics™ NAV 2013
  • Microsoft® Dynamics™ NAV 2013 R2

  • Microsoft® SQL Server™ 2000
  • Microsoft® SQL Server™ 2005
  • Microsoft® SQL Server™ 2008
  • Microsoft® SQL Server™ 2008 R2
  • Microsoft® SQL Server™ 2012
5. Edition (2014)
As this book is actually outdated and I do not find the time to update it, I have cancelled this project - it is out of print since 2020.
You can download it here FOR FREE as "Legacy Edition"!
Download NAV/SQL Performance Field Guide
Download NAV/SQL Performance Field Guide