Directions EMEA 2019 – Session “NAV/SQL Performance in a Nutshell” (NSFW)

Title:
NAV/SQL Performance in a Nutshell

Warning:
This session is going to be rude, insulting and slightly pornographic!
NOT SAFE FOR WORK!

Skill:
100-200, Business

Abstract:
No worries, this session will not bother you with annoying technical details about performance optimization. I will try to describe – in simple terms – the general challenges, approaches and necessity of tuning and troubleshooting.
This should help you – Dynamics Partners, Resellers and Consultants – to explain to your customers, why there actually are “performance issues” and how they could be resolved (mostly).
I will also somewhat spoil your “Cloud-enthusiasm”, explaining the risks and limitations in terms of performance-optimization.

Slides:
NAVSQLPerformance_Nutshell_DirectionsEMEA2019

Directions EMEA 2019 – Workshop “SQL Server Configuration & The Magic 7”

Title:
SQL Server Configuration & The Magic 7

Skill:
200-300, Technical

Abstract:
First we will configure an SQL Server instance according to common best-practice, to establish a solid basis for good performance.
Then I will walk you through just 7 generic* TSQL scripts which will help you to easily identify bottlenecks and to fix several crucial problems.
*) these scripts work (more or less) from SQL version 2005 to 2017 independent of any application (no matter if NAV, BC, AX, CRM, … you name it)!

Prerequisites:
Bring your own Laptop! You need to have a locally pre-installed up-running SQL Server installation – any SQL Version (2005 to 2017) with an application of your choice (preferably NAV version 4.0 SP3 to BC).
The SQL “Edition” should be at least STANDARD, DEVELOPER or ENTERPRISE (not EXPRESS); incl. SQL Agent, Management Studio; maybe also SQL Profiler and “Books Online”.
You probably will not be able to access any remote installation through internet etc. but you could give it a try.

You’ll find all the required scripts here:
https://sourceforge.net/projects/magic7/
https://sourceforge.net/projects/ixadder/
https://sourceforge.net/projects/maintenancetrident/

Slides:
Maint3dent_and_Magic_7_DirectionsEMEA2019

NAV TechDays 2017: C/AL – Coding for Performance

Abstract:

There are several misunderstandings, confusions or “fake-news” around, when it is about C/AL programming and how it affects performance on SQL Server. Time to clean this up!

In this session we will explain some “DOs & DONTs” of programming NAV; showing best-practices in using certain methods and how to avoid common mistakes.

Further we will give some guidance about how to identify and troubleshoot query and code bottlenecks. Make your C/AL code rock!

Presented by Jasminka Thunes and Jörg Stryk

Presentation Slides & Scripts: NAV TechDays 2017.zip

Download Session Recording from mibuso.com: https://mibuso.com/downloads/nav-techdays-2017-c-al-coding-for-performance

Watch Session on YouTube:

Directions EMEA 2017: NAV/SQL Performance in a Nutshell

Please find attached the presentations-slides (“Safe for Work” Edition 😉 ):

Abstract:
No worries, this session will not bother you with annoying technical details about performance optimization! I will try to describe – in simple terms – the general challenges, approaches and necessity of tuning and troubleshooting. This should help you – Dynamics Partners, Resellers and Consultants – to explain to your customers, why there actually are “performance issues” and how they could be resolved (mostly); also highlighting the value of upgrading and potential risks with Cloud scenarios.

EMEA2017_PerformanceNutshell.zip