NAV/SQL Performance - My Two Cents

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

Directions EMEA 2015 - SQL Server Sizing for Performance

Please find attached the download package to the session "SQL Server Sizing & Configuration for good performance" presented at Directions EMEA 2015 in Mannheim.
http://www.directionsemea.com/agenda/session-details?tid=NAVE-02

Abstract:

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.

DirectionsEMEA2015_Stryk_SqlSizingPerformance.zip