Magic 7

Long time no see – it’s about time!

Today – 1st August 2019 – I decided to proudly publish the “Magic 7” scripts to the public!

7 Generic TSQL Scripts to Troubleshoot SQL Performance Problems

The M7 bunch of scripts should help the EXPERIENCED Troubleshooter to quickly identify bottlenecks and to develop/implement appropriate solutions.

Download Magic 7

The M7 scripts are published under GNU General Public License (V3, 29 June 2007)

It’s a collection of some basic but essential stuff I use daily (among other tools) for many years to get my job – troubleshooting & performance optimization – properly done.
Admittedly, these thingies are just doing the “grunt work”, of course there’s much more to do in terms of database tuning …
These scripts are more or less permanently “under construction” and constantly expanded and enhanced, e.g. targeting new issues or dealing with new releases of SQL Server.

I want to encourage you to share your experiences with the “Magic 7” and maybe contributing to it, making it better with every mission!


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.