Decisions Spring 2010 – NAV/SQL Performance: Blocks and Deadlocks

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.

Attachment: decisions 2010.zip
Posted: May 19, 2010 20:00 by Jörg A. Stryk | with 4 comment(s) |
Filed under: , , , , ,
Bookmark and Share

Related Posts

    No Related Posts

Comments

# re: Decisions Spring 2010 – NAV/SQL Performance: Blocks and Deadlocks

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)

Thursday, May 20, 2010 9:02 AM by Jörg A. Stryk

# re: Decisions Spring 2010 – NAV/SQL Performance: Blocks and Deadlocks

Hi Jorg,

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)

Rama Mathanmohan

Saturday, May 22, 2010 4:47 PM by Rama Mathanmohan

# re: Decisions Spring 2010 – NAV/SQL Performance: Blocks and Deadlocks

Hi,

thanks for your comment!

I didn't know about the "Alert driven Deadlock logging" so far - thanks a lot for the hint!

Cheers,

Jörg

Saturday, May 22, 2010 6:01 PM by Jörg A. Stryk

# re: Decisions Spring 2010 – NAV/SQL Performance: Blocks and Deadlocks

Was an informative presentation.  Thanks Jörg.

Saturday, May 29, 2010 1:12 AM by Kevin Lavin

Leave a Comment

(required) 
(required) 
(optional)
(required)