Masterclass: SQL Server 2017 Internals for Query Tuning with Kalen Delaney

SQL Server Internals for Query Tuning provides the internal details you need to know to make sure you can get the best performance from your SQL Server queries.

This is an advanced course designed for advanced SQL Server professionals. The course includes extensive demonstrations that illustrate the details of SQL Server internals as well as tuning techniques. This course will be presented on SQL Server 2017 and cover features specific to that version, but most of the information is relevant to SQL Server 2016 and SQL Server 2014, and some is relevant to earlier versions.

Topics to be covered include the following:

  • SQL Server Storage Metadata
  • Tools for exploring storage structures
  • Physical Storage Structures
  • Query Processing and Query Plans
  • Optimization and Recompilation
  • Index Design and Tuning
  • Statistics Internals and Management
  • Query Tuning Tips and Techniques

About Kalen Delaney

Kalen Delaney is a SQL Server MVP and has been working with SQL Server for almost 31 years, and provides advanced SQL Server training to clients around the world. She has been a SQL Server MVP since 1993 and has been writing about SQL Server almost as long. Kalen has spoken at dozens of technical conferences, including every PASS conference in the US and multiple TechEd events in both the US and Europe. Kalen is the author or co-author of many books on SQL Server, the most recent being SQL Server 2016 Internals: In-memory OLTP. Kalen’s website and blog can be found at www.



Part 1: SQL Server Metadata

  • Architecture Overview
  • Metadata Overview
  • Dynamic Management Views

Part 2:  Index Structures

  • Metadata for Storage
  • Space Allocation
  • Tools for Examining Physical Structures
  • Heaps and B-Trees
  • Clustered Indexes
  • Nonclustered Indexes
  • Fragmentation
  • Filtered Indexes
  • Rebuilding Indexes
  • Partitioning Overview
  • Creating and Maintaining Partitions
  • Metadata for Partitioning
  • Columnstore Index Storage


Part 3: Query Processing and Query Plans

  • SHOWPLAN Options
  • Query Plan Elements
  • Types of Joins
  • Aggregation
  • Sorting
  • Columnstore Index Processing
  • Data Modification
  • Query Tuning Basics

Part 4: Optimization and Recompilation

  • Optimization Overview
  • SQL Server’s Query Optimizer
  • Adaptive Query Processing
  • Plan Management and Reuse
  • Causes of Recompilation
  • Forcing Recompilation
  • Statistics Management
  • Plan Cache Metadata


Part 5: Index Tuning

  • Special Index Features
  • Statistics Internals
  • Covering Indexes
  • Filtered Indexes
  • Included Columns
  • Indexing Guidelines

Part 6: Query Tuning

  • Monitoring Tools
  • The Query Store
  • Query Improvements
  • Search Arguments
  • Constants and Variables
  • User Defined Functions
  • Plan Guides
  • Query Hints
  • Query Store
  • Automatic Plan Correction

Boka kursen

Boka din plats redan idag.

Om kursen

Pris: 29 450,00 kr

exklusive moms

Längd 3 dagar
Kurskod MC033
Boka kursen

Välj ort och kursstart

2 oktober