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.



Bookmark and Share

Comments

# re: NAV TechDays 2012 - Understanding Blocks & Deadlocks with NAV & SQL Server

Great presentation at the NAV TechDays!! :)

Thanks a lot for sharing this knowledge and information.  The sessions were all amazing! :)

Thanks,

Moira

Saturday, September 29, 2012 1:43 PM by Moira Cassar - Crimsonwing Malta

# re: NAV TechDays 2012 - Understanding Blocks & Deadlocks with NAV & SQL Server

Hi,

I tried your fobs - but can't find the changes in C80 and C90. Are these the right objects?

Cheers,

Steffen

Monday, October 01, 2012 3:28 PM by Steffen Forkmann

# re: NAV TechDays 2012 - Understanding Blocks & Deadlocks with NAV & SQL Server

Hi,

tried to import the No. Series Line fix, but it seems it is only the default table without a fix.

Can you confirm?

Wednesday, October 17, 2012 11:38 AM by Steffen Forkmann

# re: NAV TechDays 2012 - Understanding Blocks & Deadlocks with NAV & SQL Server

Was this recorded? I'd love to watch this presentation.  I found a few other sessions from Nav TechDays so I'm hopeful they were all recorded...

Thursday, October 18, 2012 7:16 PM by Aaron Zimmerman

# re: NAV TechDays 2012 - Understanding Blocks & Deadlocks with NAV & SQL Server

Yes, all sessions were recorded and are available on MIBUSO.com: www.mibuso.com/downloads.asp

Sunday, November 04, 2012 11:41 AM by Jörg A. Stryk

# re: NAV TechDays 2012 - Understanding Blocks & Deadlocks with NAV & SQL Server

The file "Changes_SSI.fob" in the "Objects" folder should contain the changed versions!

Sunday, November 04, 2012 11:57 AM by Jörg A. Stryk

# re: NAV TechDays 2012 - Understanding Blocks & Deadlocks with NAV & SQL Server

Hi Jörg

I wasn't at the Tech Days, but I just saw this presentation. Great stuff!

Are the SQL-scripts/tools available somewhere for download?

Cheers

Søren

Monday, March 18, 2013 9:39 PM by Søren Alexandersen

# re: NAV TechDays 2012 - Understanding Blocks & Deadlocks with NAV & SQL Server

Yes, the stuff is actually attached to this BLOG article ;c)

Tuesday, March 19, 2013 7:43 AM by Jörg A. Stryk