SQL Server: Analyzing Query Performance for Developers

This course will teach you everything you need to know as a developer to start making sense of query plans and improving query performance. Apart from developers, this course is also applicable to anyone who is responsible for SQL Server performance.
Course info
Rating
(60)
Level
Beginner
Updated
Sep 29, 2017
Duration
4h 2m
Table of contents
Course Overview
Introduction
Finding Information About Queries
Understanding Query Performance Metrics
Reading Query Plans
Operators in a Query Plan
Important Information in a Plan
Description
Course info
Rating
(60)
Level
Beginner
Updated
Sep 29, 2017
Duration
4h 2m
Description

Developers are sometimes charged with fixing performance issues, and they have no idea where to start. They've never seen a query plan, or when they look at one they're not sure what it really means. The developers know how long it takes for a query to execute, but they don't know how to see how much IO, CPU, or memory it uses. And sometimes they just create an index and that seems to fix the problem (even though they have no idea why!). In this course, SQL Server: Analyzing Query Performance for Developers, you'll learn about all the data that SQL Server generates when a query executes - it's more than just the query plan - and you'll learn where it exists and how to find it. First, you'll discover what the data represents and how to read a query plan. Next, you'll explore some of the query plan operators you'll see most often. Finally, you'll learn what information is included in the plan, which may not be immediately obvious, but can be extremely valuable when troubleshooting. When you're finished this course, you'll have the skills and knowledge to start examining and understanding query plans and making query changes for better performance!

About the author
About the author

Erin Stellato is a Principal Consultant with SQLskills and a SQL Server MVP. She has worked as a SQL Server professional since 2003 and her interests include Internals, Performance Tuning, High Availability and Disaster Recovery. Erin is an active member of the SQL Server community as a presenter and blogger.

More from the author
SQL Server: Introduction to Query Store
Beginner
3h 2m
Jan 31, 2017
More courses by Erin Stellato