Directions EMEA 2019 – Workshop “SQL Server Configuration & The Magic 7”

SQL Server Configuration & The Magic 7

200-300, Technical

First we will configure an SQL Server instance according to common best-practice, to establish a solid basis for good performance.
Then I will walk you through just 7 generic* TSQL scripts which will help you to easily identify bottlenecks and to fix several crucial problems.
*) these scripts work (more or less) from SQL version 2005 to 2017 independent of any application (no matter if NAV, BC, AX, CRM, … you name it)!

Bring your own Laptop! You need to have a locally pre-installed up-running SQL Server installation – any SQL Version (2005 to 2017) with an application of your choice (preferably NAV version 4.0 SP3 to BC).
The SQL “Edition” should be at least STANDARD, DEVELOPER or ENTERPRISE (not EXPRESS); incl. SQL Agent, Management Studio; maybe also SQL Profiler and “Books Online”.
You probably will not be able to access any remote installation through internet etc. but you could give it a try.

You’ll find all the required scripts here:


Author: Jörg Stryk

I’m working with MS Dynamics NAV (formerly Navision) since 1997, with SQL Server since 2003. I have a 100% focus on “Performance Optimization & Troubleshooting” (and things in touch with this).
Since 2006 I’m supporting Dynamics customers and partners within their NAV projects; so far I have supported way more than 700 projects – and counting!
I’m developing & distributing the optimization utility the “SSI Performance Toolbox” and I am the author of “The NAV/SQL Performance Field Guide” (ISBN 978-3-8370-1442-6) (discontinued).
Microsoft “Most Valuable Professional” (MVP) 2007-2017.