The SQL Server Query Optimizer creates an execution plan for every statement running in the database. Since SQL is a declarative language, we describe what data we want to see, then the SQL Server Optimizer figures out a plan to retrieve that data efficiently. However, sometimes the Optimizer chooses a bad query plan which not only makes the query run slow, but eats up resources so other processing can’t get done. This presentation will show how to read and fine tune the query plan for better performance. We’ll quickly go over the different types of execution plans and when to use them. We’ll examine the different operators, their statistics and costs, then determine which steps to focus on tuning. Finally, several trouble shooting techniques will be shown so you can increase your tuning skills.
Watch the session recording from PASS Summit 2020. For updates on the future of PASS, SQLSaturdays and PASS Summit opt in here: red-gate.com/pass
- A Deep Dive into Execution Plans & How to Use Them! - Janis Griffin ( Download)
- Advanced Plan Explorer Usage for Tuning Execution Plans - Andy Yun ( Download)
- TSQL Execution Plan Operator - Filters ( Download)
- Advanced Plan Explorer Usage for Tuning Execution Plans by Andy Yun ( Download)
- Advanced Plan Explorer Usage for Tuning Execution Plans — Andy Yun ( Download)
- Advanced Plan Explorer Usage for Tuning Execution Plans ( Download)
- Explain the Explain Plan Interpreting Execution Plans for SQL Statements Part 2 ( Download)
- Do You Feel the Need the Need for Speed in SQL Server Database - J Griffin ( Download)
- MOUS Monday - Dec. 28, 2020 - Janis Griffin - Oracle 19c Automatic Indexing Inside & Out! ( Download)
- Foglight for SQL Server Encryption Check ( Download)
- MOUS Monday - Dec. 28, 2020 - Janis Griffin - Oracle 19c Automatic Indexing Inside & Out! ( Download)
- A Deep Dive Strategy session helps you find and keep the right person for your company ( Download)
- A Beginner's Guide to Becoming a Performance Tuner - Andy Yun ( Download)
- How to Prepare for a Deep Dive Strategy Session ( Download)
- Utah SQL Server Group - Beginners Guide to Perf Tuning - Developer ( Download)
