NAV/SQL Performance in a Nutshell
This session is going to be rude, insulting and slightly pornographic!
NOT SAFE FOR WORK!
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.
SQL Server Configuration & The Magic 7
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)!
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:
Please find attached the presentations-slides (“Safe for Work” Edition 😉 ):
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.
NAV/SQL Performance – Optimizing [not-so?] Smart-Queries
Query- and Index-Tuning in general are the most important aspects in optimizing performance in Dynamics NAV. Since NAV 2013 here a new “challenge” was introduced: SmartQueries! These SQ often turn out not being so smart at all, then causing seriously degraded performance and user-experience.
In this session it will be explained how to troubleshoot such issues, discussing options about diagnosis and resolution; also highlighting the special challenges in Cloud based scenarios.
Please find attached the related download-package containing the PowerPoint slides, Examples and essential Tuning Scripts.
Directions EMEA 2016.zip
Registration is now open for NAV TechDays 2016, from 17th-18th November 2016 in Antwerp/BE.
Attend the greatest NAV conference in the world here: https://www.navtechdays.com/
As before, there will be also several pre-conference workshops – but this year there’ll be TWO workshop days – 15th & 16th November 2016!
Due to the throughout positive feedback I’ll – again – present the workshop “NAV/SQL Troubleshooting Essentials“. This is a compressed version of the regular “Masterclass” training which normally takes two days. Though, we have decided to still run the ONE day workshop (= compressed content) and repeat that on day number TWO!
This should give you the chance to attend two different workshops at NTD if you like; also I’m able to present the content to a greater audience, as in the past my workshops have been fully booked very quick.
See the sessions (yet not complete) and workshops here:
Looking forward to meeting you in Antwerp!