MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SQL Server: Query Plan Analysis

Course Summary

SQL Server query plans contain a wealth of information that can be used to diagnose performance problems, but at first glance they appear complicated and difficult to understand. With more than 30 detailed demos, this course shows you how to easily unders


  • +

    Course Syllabus

    ● Course Introduction
        ◦ Course Introduction
        ◦ Why Do We Care About QPs?
        ◦ What Doesn't a Query Plan Tell Us?
        ◦ Course Structure
    ● Capturing Query Execution Plans
        ◦ Module Introduction
        ◦ Capturing a Plan
        ◦ Demo: Capturing a Plan
        ◦ Why Deprecate?
        ◦ DMOs
        ◦ Demo: DMOs
        ◦ SQL Trace and Extended Events
        ◦ Demo: Using Extended Events to Capture Execution Plans
        ◦ Graphical Showplan
        ◦ Demo: Graphical Showplan
        ◦ SQL Sentry Plan Explorer
        ◦ Demo: SQL Sentry Plan Explorer
        ◦ Estimated vs. Actual
        ◦ Demo: Estimated vs. Actual
    ● Interpreting Query Execution Plans
        ◦ Module Introduction
        ◦ Iterators / Operators
        ◦ Query Tree
        ◦ Operator Cost (1)
        ◦ Operator Cost (2)
        ◦ Demo: Operator Cost
        ◦ Operator Memory (1)
        ◦ Operator Memory (2)
        ◦ Demo: Operator Memory
    ● Common Operators
        ◦ Module Introduction
        ◦ Table and Index Scans
        ◦ Demo: Table and Index Scans
        ◦ Index Seeks
        ◦ Demo: Index Seeks
        ◦ Lookups
        ◦ Demo: Lookups
        ◦ Join Considerations
        ◦ Outer / Inner Terminology
        ◦ Demo: Outer / Inner Terminology
        ◦ Nested Loop
        ◦ Demo: Nested Loop
        ◦ Merge Join
        ◦ Demo: Merge Join
        ◦ Hash Match Join
        ◦ Demo: Hash Match Join
        ◦ Filter
        ◦ Demo: Filter
        ◦ Stream Aggregate
        ◦ Demo: Stream Aggregate
        ◦ Hash Match (Aggregate)
        ◦ Demo: Hash Match Aggregate
        ◦ Sort
        ◦ Demo: Sort
        ◦ Spools
        ◦ Eager Spool and 'Halloween Protection'
        ◦ Demo: Eager Spool
        ◦ Constant Scan
        ◦ Demo: Constant Scan
        ◦ Assert
        ◦ Demo: Assert
        ◦ Compute Scalar
        ◦ Demo: Compute Scalar
        ◦ Identifying Parallelism in the Plan
        ◦ Exchange Operators
        ◦ Demo: Exchange Operators
        ◦ Bitmap
        ◦ Demo: Bitmap
        ◦ Merge Interval
        ◦ Demo: Merge Interval
        ◦ Concatenation
        ◦ Demo: Concatenation
        ◦ Segment and Sequence Project
        ◦ Demo: Segment and Sequence Project
    ● Noteworthy Patterns
        ◦ Module Introduction
        ◦ The 'Basics'
        ◦ Demo: Missing index warnings
        ◦ Lookups
        ◦ Nested Loop Patterns
        ◦ Merge Join Patterns
        ◦ Demo: Merge Join Overhead
        ◦ Hash Join Patterns
        ◦ Demo: Hash Join Spills
        ◦ Stop-and-Go Operators
        ◦ Sort Patterns
        ◦ Aggregates
        ◦ Predicates
        ◦ Spool Overhead
        ◦ Parallelism Performance Aspects
        ◦ Data Modification Plan Patterns
        ◦ Demo: Data Modification Plan Patterns
        ◦ Cardinality Estimate Issues
        ◦ Data Type Conversions
        ◦ PlanAffectingConvert
        ◦ Demo: PlanAffectingConvert
        ◦ NoJoinPredicateWarning
        ◦ Columns


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management and Digital Media & Games Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top