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 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)
DISCONTINUED
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"!