Global - (+34) 91 414 89 50 | N. America - (800) 757 6543 contact@solidq.com

COURSE: SQL Server Execution Plans

Master your T-SQL Querying, Query Tuning and Programming skills. Create highly efficient solutions to your common business tasks

Any professional working with the SQL Server relational engine should be able to understand an execution plan to stop seeing the engine as a black box and be able to focus on taking advantage of it to get the maximum benefit.

 

If you’re looking for an advanced course, check out SQL Server Execution Plans Advanced

COURSE DELIVERY OPTIONS

1-DAY CLASSROOM

The course will take place in a classroom with no more than 20 students in order to maintain a good level of interactivity.

PRIVATE ONSITE

The course will take place in your company’s facilities. We limit attendance to no more than 20 students in order to maintain a good level of interactivity. Request quote here.

Course Benefits

During this one-day course, you will learn how to read execution plans with SQL Server 2016. You will see the most frequent operators as well as a variety of queries and T-SQL solutions that have quite practical application in day to day.
Being able to read execution plans SQL Server gives the database developer the ability to decide whether the solution that SQL Server has encountered for query execution is optimal or if on the contrary we must modify something, whether query, indexing, plan guides, …to improve it.

Any professional working with the SQL Server relational engine should be able to understand an execution plan to stop seeing the engine as a black box and be able to focus on exploiting it to get the maximum benefit.

Who is this course for?

This course is designed for both DBA and developers working with SQL Server. The target audience is both the professional in charge of writing the required query and the DBA that manages the resources of the SQL Server instances and must decide if there are queries that are putting the performance of the system at risk. This course is focused on professionals who have some experience with SQL Server. It’s recommended understanding of the relational model, as well as the T-SQL language

Expert Mentors

Our instructors have faced in previous real case projects, the same problems you are facing now. Learn from experience professionals.

t

Interaction and Q&A

In all of our trainings, you will have the chance to ask individual questions and be capable of solving certain issues.

Course Coverage

 

h

Read execution plans

t

See a plan and understand if you need help from you

e

Understand the statistics and histograms of objects

l

What indices to create, if they make sense and why to make them

Understand whether a query is well formulated or can be improved

“It has given me knowledge to begin to understand the execution plans and thus to know how to improve my queries to the database, thus minimizing access and time in the consultations.”

COURSE OUTLINE

Module 01: Introduction

  • SQL Server Management Studio

Module 02: Generation of execution plans

  • Query Optimizer
  • What is an Execution Plan?
  • Viewing an Execution Plan
  • Reading an Execution Plan
  • Display Modes
  • Plans Vs. Real
  • Operators
  • Tips

Module 03: Statistics

  • What are they
  • Properties
  • Updating statistics
  • Viewing statistics
  • How to read a histogram
  • Selectivity
  • Density
  • Cardinality
  • SARGs
  • Practical cases
  • Tips

Module 04: Operators

  • What are they
  • Logical Operators vs Physical Operators
  • Table Scan
  • NonClustered index scan
  • Clustered index scan
  • Index seek
  • Merge interval
  • Key lookup
  • Rid lookup
  • Spools
    • Eager/Lazy Spool
    • Row count spool
    • Table Spool
    • Nonclustered Index spool
  • Stream aggregate
  • Assert
  • Concatenation
  • Compute scalar
  • Segment
  • Sort
  • Paralell operators
    • Distributed streams
    • Repartition streams
    • Gather streams
  • JOIN operators
    • Nested loop
    • Hash join
    • Merge join

Module 05: Advanced

  • Using the Execution Plans Cache
  • Examine and manipulate
    • Forced parameterization
    • Optimzie adhoc for workloads
    • Parameter sniffing
    • Optimize for
    • Guided Plans
    • Patronization and bifurcation
    • Automatic recompilations

Would you like to register for this course?

Fill out the form at the top of this page