NAVSQL Performance Jrg Stryk Vienna Austria 9 11
- Slides: 27
NAV/SQL Performance Jörg Stryk Vienna, Austria 9 -11 October 2019
Welcome! STRYK System Improvement Performance Optimization & Troubleshooting Jörg A. Stryk E-Mail: Web: contact@stryk. info http: //www. stryk. info/ https: //sourceforge. net/u/jstryk/
NAV/SQL Performance for Dummies In a Nutshe General challenges & approaches to exceed the limits © STRYK System Improvement – Jörg A. Stryk
Warning! This session is going to be Rude, insulting and Slightly pornographic. If you are easily offended LEAVE NOW!
Jörg Stryk – If your NAV sucks, it wasn’t fixed by me! MS Dynamics NAV (Navision) since 1997 Since version 1. 2 MS SQL Server since 2003 Since version 2000 100% focus on NAV/SQL Performance Optimization STRYK System Improvement (since 2006) More than 500 projects in about 25 countries on 5 continents (Dec 2016) Worldwide support of MS Dynamics Partners & Customers Microsoft Most Valuable Professional MVP MS Dynamics NAV 2007 -2017 Book: Software: “NAV/SQL Performance Field Guide” “SSI Performance Toolbox” (retired) ISBN 978 -3 -8370 -1442 -6 http: //www. stryk. info/toolbox. html
LISTEN Up, MICROSOFT! This PRODUCT IS CALLED NAVISION or NAV I DON‘T GIVE A F*** ABOUT HOW YOU LABEL IT!
Sense and Relativity of Time
Sense and Relativity of Time
Troubleshooting It is a mistake to think you can solve any major problems just with potatoes. Measure App Everything 's S 80% Nothing Works Database Implement Analyze SQLServer Decide Douglas Adams Infrastructure Infra.
Performance Areas Blocks & Deadlocks Query. Strategy & Indexing Platform & Hardware
Performance Areas Blocks & Deadlocks Query. Strategy & Indexing Platform & Hardware
Requirements
Requirements for Requirements Windows Foundation CPU Server 2008 Server 2016 Server 2019 CPU n/a Server 2008 R 2 Server 2012 R 2 RAM Essential RAM Standard Enterprise CPU RAM CPU 4 32 GB 8 1 TB 4 32 GB 8 SQL RAM Standard Enterprise CPU RAM Server 2008 4 max max 2 TB Server 2008 R 2 4 64 GB max max 128 GB max max Max 1 32 GB 2 64 GB 64 4 TB Server 2012 4/16 1 32 GB 2 64 GB 64 4 TB Server 2014 Server 2016 4/16 Server 2017 Server 2019
Performance Areas Blocks & Deadlocks Query. Strategy & Indexing Platform & Hardware
Core Architecture What you Want What you Get
Data Retrieval
Performance Areas Blocks & Deadlocks Query. Strategy & Indexing Platform & Hardware
Blocking Probability
Performance Areas Blocks & Deadlocks Query. Strategy & Indexing Platform & Hardware
Tuning
There is no Cloud. . . You Manage Vendor Manages „Pizza As A Service“ Analogy On-Premise Dining Table Soda Electric/Gas Oven Fire Dough Tomato Sauce Toppings Cheese Made at Home Infrastructure Platform as a Service (Iaa. S) (Paa. S) Dining Table of Dining Increase Service. Table ? Soda Electric/Gas Oven Loss of Control Oven !? Fire Dough Tomato Sauce Decrease of Performance ! Toppings Cheese Take & Bake Delivered Software as a Service (Saa. S) Dining Table Soda Electric/Gas Oven Fire Dough Tomato Sauce Toppings Cheese Dined Out
Tuning in ”The Cloud”
”The Cloud” - What if. . . ?
Evolution? Not really. . .
Yes, We Can! So far. . .
Annoying Questions & Stupid Answers DON‘T BE AN ASKHOLE To not embarrass the speaker please only ask questions where the answer is either simple or obvious. Thanks a bunch!
Thank You! STRYK System Improvement Performance Optimization & Troubleshooting Jörg A. Stryk E-Mail: Web: contact@stryk. info http: //www. stryk. info/ https: //sourceforge. net/u/jstryk/
