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.