NAV/SQL Performance - My Two Cents

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

NAV TechDays 2012 - Understanding Blocks & Deadlocks with NAV & SQL Server


Blocks and Deadlocks are a major issue in NAV/SQL systems; causing decreased performance and poor user experience. This session will explain the locking mechanisms with Dynamics NAV and SQL Server and how they could be properly used. Further it will be demonstrated how blocks & deadlocks could be easily monitored and analyzed to get clues about the problem’s origin and to find appropriate solutions.

Some practical examples will highlight common problems and give inspiration for practicable solutions.

NAV TechDays