SQL Server: Analyzing Query Performance for Developers

Focused View

Erin Stellato

3:54:25

45 View

01 - Course Overview.mp4

01:46

02 - Introduction and Why We Need to Understand Query Execution.mp4

03:46

03 - Course Objectives and Structure and Module Summary.mp4

03:01

04 - Introduction and Information About Queries.mp4

02:43

05 - Demo - Viewing Live Query Execution Data.mp4

08:59

06 - Finding Query Execution Data and Extended Events.mp4

03:11

07 - Demo - Query Information from Extended Events.mp4

05:25

08 - Dynamic Management Objects.mp4

00:50

09 - Demo - Query Execution Data in DMOs.mp4

08:05

10 - Query Store and Performance Monitor.mp4

02:33

11 - Demo - Query Metrics From Performance Monitor.mp4

05:08

12 - A Note About Estimated and Actual Plans and Module Summary.mp4

01:55

13 - Introduction and Query Metrics of Interest.mp4

02:43

14 - SSMS, Extended Events, DMOs, and Query Store.mp4

03:09

15 - Demo - Viewing and Interpreting Query Execution Data.mp4

02:19

16 - Module Summary.mp4

00:33

17 - Introduction and What is a Plan.mp4

01:51

18 - Whats in a Plan and Whats Not in a Plan.mp4

04:26

19 - Reading Plans.mp4

02:19

20 - Demo - How to Start Looking at a Query Plan - Part 1.mp4

09:53

21 - Demo - How to Start Looking at a Query Plan - Part 2.mp4

09:31

22 - Module Summary.mp4

00:49

23 - Introduction and What Do You Look for in a Plan.mp4

02:19

24 - Scans and Seeks.mp4

01:44

25 - Demo - Data Access Operators.mp4

15:44

26 - Nested Loop and Lookups.mp4

02:16

27 - Demo - Nested Loops and Lookups.mp4

10:52

28 - Merge Join and Sort.mp4

02:58

29 - Demo - Merge Join and Sorts.mp4

17:31

30 - Hash Join.mp4

01:42

31 - Demo - Hash Join.mp4

09:33

32 - Compute Scalar.mp4

01:21

33 - Demo - Compute Scalar.mp4

06:26

34 - Module Summary.mp4

01:06

35 - Introduction and Input Parameters.mp4

02:05

36 - Demo - Finding Input Parameters in a Plan.mp4

09:33

37 - Trace Flags.mp4

01:02

38 - Demo - Trace Flags in a Query Plan.mp4

07:05

39 - Cardinality Estimator Version and Issues.mp4

02:11

40 - Demo - Examining CE Version and Estimates.mp4

11:05

41 - Operator Execution Statistics.mp4

01:04

42 - Demo - Execution Statistics for Operators.mp4

06:30

43 - Parallelism.mp4

03:44

44 - Demo - Parallelism in Plans.mp4

07:56

45 - Seek Predicate and Residual Predicate.mp4

01:51

46 - Demo - Seek and Residual Predicates.mp4

10:04

47 - Warnings.mp4

01:09

48 - Demo - Generating Plan Warnings.mp4

07:42

49 - Module and Course Summaries.mp4

02:57

File.zip

Description

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.

What You'll Learn?

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!

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Microsoft SQL

Erin Stellato

Instructor's Courses

Erin Stellato is a Principal Consultant with SQLskills and a SQL Server MVP. She has worked as a SQL Server professional since 2003, spending 12 years of her career at two different software companies. Erin discovered a passion for all things data while completing her M.S. in Motor Control at the University of Michigan. As she entered the IT field, she discovered the power of relational databases. During her IT career, Erin has worked closely with customers, users and colleagues to support business solutions across a variety of industries including healthcare, insurance, finance and government. These experiences provided opportunities to see varied implementations, troubleshoot hardware-related problems, give guidance on configuration and design, and provide consultation on optimization, availability and recoverability. Not surprisingly, Erin’s interests include Internals, Performance Tuning, High Availability and Disaster Recovery. More than anything though, she likes to know how SQL Server works, so she can fix it when it breaks. Erin is an active member of the SQL Server community. She currently runs the PASS Performance Virtual Chapter and is involved in the Ohio North SQL Server User Group. She also presents at user groups, SQLSaturdays and the PASS Summit, and blogs about her experiences on her personal blog (http://www.erinstellato.com) and at SQLskills

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.