Directions EMEA 2016 – SmartQuery Tuning

NAV/SQL Performance – Optimizing [not-so?] Smart-Queries

Abstract:

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