See how Insoft Services is responding to COVID-19

Masterclass Advanced NAV/SQL Performance Optimization

X

Kontaktiere uns

Wir würden uns freuen, von Ihnen zu hören. Bitte füllen Sie dieses Formular aus, um vorab zu buchen oder um weitere Informationen zu unseren Angebotsmöglichkeiten anzufordern.

Abonnieren

Ich möchte E-Mails mit den neuesten Informationen und Werbeaktionen von Insoft erhalten.

Datenschutz & Privatsphäre

Hiermit erlaube ich Insoft Ltd., mich zu diesem Thema zu kontaktieren. Des Weiteren ermächtige ich Insoft Ltd., meine personenbezogenen Daten für die Zwecke dieser Aktivitäten zu sammeln und zu speichern. Alle Ihre Daten werden gemäβ unserer Datenschutzrichtlinie geschützt und gesichert.


Schulungsplan


Oct 12 - Oct 13, 2020
09:00 - 17:00 (CEST)
Online

Feb 1 - Feb 2, 2021
09:00 - 17:00 (CEST)
Online

May 6 - May 7, 2021
09:00 - 17:00 (CEST)
Online

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

Nov 3 - Nov 4, 2021
09:00 - 17:00 (CEST)
Online

  • Masterclass Advanced NAV/SQL Performance Optimization
    2 days  (Instructor Led Online)  |  Microsoft Dynamics NAV
    €1200 (Excl. VAT)
    Buchen

    Course Details

    Kursbeschreibung

    This two day course will be a deep dive into the areas of performance troubleshooting a NAV/SQL system – platform/infrastructure, query strategy/programming and blocking/deadlocking.
    It will be explained 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.

    Kursziele

    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

     

    Zielgruppe

    • experienced NAV/SQL Administrators
    • experiences NAV Developers

     

    Voraussetzungen

    • 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.