Jörg Stryk (MVP - Dynamics NAV) about Performance Optimization & Troubleshooting with MS Dynamics NAV and MS 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.
Great presentation at the NAV TechDays!! :)
Thanks a lot for sharing this knowledge and information. The sessions were all amazing! :)
I tried your fobs - but can't find the changes in C80 and C90. Are these the right objects?
tried to import the No. Series Line fix, but it seems it is only the default table without a fix.
Can you confirm?
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...
Yes, all sessions were recorded and are available on MIBUSO.com: www.mibuso.com/downloads.asp
The file "Changes_SSI.fob" in the "Objects" folder should contain the changed versions!
I wasn't at the Tech Days, but I just saw this presentation. Great stuff!
Are the SQL-scripts/tools available somewhere for download?
Yes, the stuff is actually attached to this BLOG article ;c)