NAV/SQL Performance - My Two Cents

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

Please find attached the download package to the session "SQL Server Sizing & Configuration for good performance" presented at Directions EMEA 2015 in Mannheim.


A well sized and configured SQL Server platform is the basis of good performance. “Going into the Cloud” is not everybody’s cup-of-tea, thus on premise installations, virtual environments and private-clouds are most common scenarios. In this session some key-aspects will be explained, about how to size memory, CPU and disk-subsystem properly, to create a robust and scalable platform – here highlighting the “challenges & problems” one might face; also discussing “virtual” versus “physical” scenarios and more. Further it will be shown how to monitor such a system, e.g. using Windows Performance Monitor and some third party tools, to quickly learn about issues and to start troubleshooting if necessary.