See how Insoft Services is responding to COVID-19

Masterclass Advanced NAV/SQL Performance Optimization

X

Contact Us

We would love to hear from you. Please complete this form to pre-book or request further information about our delivery options.

Subscribe

I'd like to receive emails with the latest updates and promotions from Insoft.

Data Protection & Privacy

I hereby allow Insoft Ltd. to contact me on this topic. Further, I authorise Insoft Ltd. processing, using collecting and storing my personal data for the purpose of these activities. All your data will be protected and secured as outlined in our privacy policy.


Upcoming Courses

Feb 15 - Feb 16, 2021
09:00 - 17:00 (CEST)
Online

May 12 - May 13, 2021
09:00 - 17:00 (CEST)
Online

Aug 17 - Aug 18, 2021
09:00 - 17:00 (CEST)
Online

Nov 9 - Nov 10, 2021
09:00 - 17:00 (CEST)
Online

  • Masterclass Advanced NAV/SQL Performance Optimization
    2 days  (Instructor Led Online)  |  Microsoft Dynamics NAV

    Course Details

    The NAV/SQL Performance Optimization (Advanced Masterclass) is a two-day course that presents a deep-dive into the areas of performance troubleshooting a NAV/SQL system – platform/infrastructure, query strategy/programming and blocking/deadlocking.

    This course explains where problems can originate from, how to detect & analyze them, and finally how to potentially resolve them. Doing so, plenty of useful tools will also be demonstrated and provided, to enable the attendees to start the optimization of their NAV/SQL systems themselves.

     

    See other Microsoft courses

    Objectives

    Day 1 – Session 1:

    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 NST

    Session 2:

    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”
    • VSIFT

     

    Day 2 – Session 3:

    Locking Mechanisms:

    • Lock Modes
    • Lock Granularity
    • Transaction Isolation Levels

    Block Detection:

    • Detecting Blocks
    • Detecting Deadlocks
    • Prevention & Resolution

    Session 4:

    Miscellaneous:

    • Database Maintenance
    • Backup Strategy & High Availability
    • Security & Auditing
    • Data Compression

    Target Audience

    • experienced NAV/SQL Administrators
    • experiences NAV Developers

     

    Prerequisites

    Before taking the Masterclass Advanced NAV/SQL Performance Optimization course you would need:

    • General knowledge about computer hardware and Windows OS.
    • Basic knowledge and experience in SQL Server and Dynamics NAV installation & configuration.
    • Advanced knowledge and experience in NAV programming.