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
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 as a freelancer; so far I have supported more than 500 projects in 25 countries on 5 continents - 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).
Microsoft "Most Valuable Professional" (MVP) 2007-2017.
View all posts by Jörg Stryk
