Directions EMEA 2016 – SmartQuery Tuning

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

Author: Jörg Stryk

I’m working with MS Dynamics NAV (formerly Navision) since 1997, with SQL Server since 2003. I have a 100% focus on “Performance Optimization & Troubleshooting” (and things in touch with this).
Since 2006 I’m supporting Dynamics customers and partners within their NAV projects; so far I have supported way more than 700 projects – and counting!
I’m developing & distributing the optimization utility the “SSI Performance Toolbox” and I am the author of “The NAV/SQL Performance Field Guide” (ISBN 978-3-8370-1442-6) (discontinued).
Microsoft “Most Valuable Professional” (MVP) 2007-2017.