Advanced NAV/SQL Performance Optimization – Fixing Trouble with Microsoft Dynamics NAV and Microsoft SQL Server

Trainer : Jorg Stryk, Microsoft MVPJorgStryk

Classroom presentation with demonstrations

Skill: 300-400 (Advanced/Expert)

Languages : English or German

Duration: 1.5 – 2 days

Day 1

Session 1 (ca. 2 – 3 hrs):

  • Windows Performance Monitoring
    • Windows Performance Monitor
    • PAL
  • Fundamental Setup
    • SQL Server Environment
    • Configuration of SQL Server and Database
    • SQL Server Wait Statistics
    • NAV Client/Service Tier Environment
    • Configuration of NSTSession 2 (ca. 4 – 5 hrs):
    • Query Strategy
      • Indexes with NAV & SQL
      • Expensive Queries & SQL Profiling
      • Query Execution Plans & Missing Index Proposals
    • C/AL Programming
      • FIND commands
      • NAV 2013+: “SQL Trace” & “NAV Application Profiler”
      • VSIFTDay 2:Session 3 (ca. 3 – 4 hrs):
    • Locking Mechanisms
      • Lock Modes
      • Lock Granularity
      • Transaction Isolation Levels
    • Block Detection
      • Detecting Blocks
      • Detecting Deadlocks
      • Prevention & ResolutionSession 4 (optional, time permitting):
  • Miscellaneous
    • Database Maintenance
    • Backup Strategy & High Availability
    • Security & Auditing
    • Data Compression