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)

 

Abstract:

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: http://www.mibuso.com/dlinfo.asp?FileID=1398

 

NAV TechDays 2011.zip