Jörg Stryk (MVP - Dynamics NAV) about Performance Optimization & Troubleshooting with MS Dynamics NAV and MS SQL Server
Directions EMEA 2010 from 19th to 21st May 2010 in Prague/CZ.Website: http://www.directionsemea.com/
Well, actually this is not some new stuff, actually the presentation is quite similar (but stronger focus on indexes) than this one:http://dynamicsuser.net/blogs/stryk/archive/2010/02/10/technical-airlift-2009-munich-nav-sql-performance-optimization-indexes.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.
Let the show begin ...
During the presentation: disrupting "Yellow Pages" to demo a "heap"
After the session: chat with Erik and Rene (who took the picture)
(Pictures courtesy of Rene Gayer - thanks a lot )
Ups ... I just realized:
In the script "Directions2010_IndexDefragmentation.sql" the part "EXEC (@command);" was commented out.
So please replace this line ...
... with this one:
Sorry! (the attached script to this BLOG was updated now)