See how Insoft Services is responding to COVID-19

Masterclass Advanced NAV/SQL Performance Optimization

Masterclass Advanced NAV/SQL Performance Optimization -
X

Contattaci

Ti preghiamo di compilare questo modulo per prenotare in anticipo o richiedere ulteriori informazioni sulle date disponiibili.

Iscriviti

Vorrei ricevere e-mail con gli ultimi aggiornamenti e le promozioni di Insoft.

Protezione dei dati e privacy

Con la presente autorizzo Insoft Ltd. a contattarmi su questo argomento. Inoltre, autorizzo Insoft Ltd. al trattamento dei miei dati personali, utilizzando la raccolta e la memorizzazione dei miei dati personali per lo scopo di queste attività. Tutti i vostri dati saranno protetti e protetti come indicato nella nostra politica sulla privacy.


Schedulazione

  Feb 22 - Feb 23, 2021
Online

  Jun 8 - Jun 9, 2021
Online

  Aug 24 - Aug 25, 2021
Online

  Nov 24 - Nov 25, 2021
Online

  • 2 Days Course
    Microsoft Dynamics NAV

    Online

    Descrizione

    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.

    Obiettivi

    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

     

    Pubblico di destinazione

    • experienced NAV/SQL Administrators
    • experiences NAV Developers

     

    Prerequisiti

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