Microsoft Dynamics NAV Deadlocks Version 2.0

This blog post is a continuation of a previous post about dealing with deadlocks in NAV. That post presented two possible solutions of how to locate and terminate the offending session that was causing the deadlock. One solution was to view the Database Sessions in the classic client, and then delete the session. The other was to use SQL Server and use TSQL queries to locate and terminate.

Bron : ArcherPoint
Lees meer…

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.

Bron : NAV/SQL Performance – My Two Cents
Lees meer…