NAV/SQL Performance - My Two Cents

Jörg Stryk (MVP - Dynamics NAV) about Performance Optimization & Troubleshooting with MS Dynamics NAV and MS SQL Server

29th to 30th September 2011 in Antwerp (Belgium)



With Dynamics NAV and SQL Server it is important to understand how “Keys” and “Indexes” actually work; how they could/should be used within the C/AL code, which problems they could cause and how those could be solved. “Indexes” could have a dramatic impact on the system’s performance, thus learning to optimize them could give a huge benefit.
The session will explain the general aspects of “Indexes” and “Keyes” with NAV and SQL and how the C/AL code is affected by those. Further it will be shown how “Index” related problems could be investigated, analyzed and finally solved.

Download the session video here:


NAV TechDays