Understanding Blocks & Deadlocks – Theory and Practice

Luc_VanDyck

Session title: Understanding Blocks & Deadlocks – Theory and Practice
Date: Friday, 28 september 2012
Time: 11:00 - 12:30
Level: 300 - Advanced, 400 - Expert
Speaker: Jörg Stryk

Session description:
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.

Use this thread to post your questions, comments or things you would like to see in this session at the conference.

stryk

Hi folks,

I guess we'll have plenty of time for :?: & :!: during (or actually after) that session, so please feel to post your questions (or wishes!) here so I could preprare something!

Looking forward to meeting you in Antwerp

Cheers,
Jörg

stryk

OK - obviously no questions I could/should prepare! Looking forward to meeting you in Antwerp!

jordi79

Hi Stryk,

Heard your talk in NAV Techdays at antwerp. Can you tell me where I can download the presentation slides? I did not take down the notes on that day, can want to recall on some tips you presented on optimisation.

cheers.

stryk

Here you could find the slides: http://dynamicsuser.net/blogs/stryk/archive/2012/09/28/nav-techdays-2012-understanding-blocks-amp-deadlocks-with-nav-amp-sql-server.aspx
In short time you should find the slides and the session-recording here on MIBUSO!

mdPartnerNL

can't wait..