Jörg Stryk (MVP - Dynamics NAV) about Performance Optimization & Troubleshooting with MS Dynamics NAV and MS SQL Server
Decisions Spring 2010 from 19th to 20th May 2010; MSDynamicsWorld.com's spring online conference and trade show, is coming to your desktop, live!Website: http://decisions.msdynamicsworld.com/
Well, actually this is not some new stuff, actually the presentation is quite similar (but shorter due to time) than this one:http://dynamicsuser.net/blogs/stryk/archive/2008/11/03/blocks-amp-deadlocks-in-nav-with-sql-server.aspx
The scripts & templates (attached) have been improved.
ALL SCRIPTS, TEMPLATES ETC. ARE PROVIDED "AS IS". NO WARRANTY, NO GUARANTEE, NO SUPPORT. USE AT OWN RISK.
Hi. I'm sorry, but the video is only available up to 90 days after the presentation. The slides could be downloaded from this BLOG (see attachment).
I handle NAV in my organization in India and we have recently upgraded to NAV2009SP1. We have been facing the locking problem during closing for the last few quarters but so far we haven't been able to resolve it. We have tried SQL indexing.
I would be grateful if you can share your PPT or the video with me at firstname.lastname@example.org as I was unable to view the video on the link given by you.
Thanks in advance!
Was an informative presentation. Thanks Jörg.
thanks for your comment!
I didn't know about the "Alert driven Deadlock logging" so far - thanks a lot for the hint!
Thanks for sharing this. I use SQL Alert driven Deadlock Logging see technet.microsoft.com/.../ms186385.aspx for detail to setup. Then you need to write bit of XQuery to analyse the data. I use this method quite heavily and if you want the XQuery, please drop me an EMail (I hope you can rememeber me from couple of years ago from your Blocking Blog)
This session has been recorded - you can still watch the presenation at "Decisions 2010":
1) Visit decisions.msdynamicsworld.com
2) Enter the Conference (you have to be registered)
3) Go to the "Auditorium"
4) Select the "NAV" track
5) Select the "NAV/SQL Performance - Indexes" session and click "View"
6) Select "Slides" and start the "Video" (doubleclick)
Enjoy it ;c)