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

Learn how to interpret and analyze SQL Server query plans, making performance problems easier to recognize and understand, applicable to developers, DBAs, and anyone responsible for SQL Server, from SQL Server 2005 onwards


  • +

    Course Syllabus

    Course Introduction
    - 3m 41s

    —Course Introduction 1m 2s
    —Why Do We Care About QPs? 1m 0s
    —What Doesn't a Query Plan Tell Us? 1m 3s
    —Course Structure 0m 36s
    Capturing Query Execution Plans
    - 31m 6s

    —Module Introduction 0m 37s
    —Capturing a Plan 1m 34s
    —Demo: Capturing a Plan 5m 2s
    —Why Deprecate? 0m 52s
    —DMOs 1m 12s
    —Demo: DMOs 2m 57s
    —SQL Trace and Extended Events 0m 39s
    —Demo: Using Extended Events to Capture Execution Plans 3m 29s
    —Graphical Showplan 1m 12s
    —Demo: Graphical Showplan 4m 36s
    —SQL Sentry Plan Explorer 0m 43s
    —Demo: SQL Sentry Plan Explorer 2m 52s
    —Estimated vs. Actual 1m 26s
    —Demo: Estimated vs. Actual 3m 55s
    Interpreting Query Execution Plans
    - 13m 24s
    Common Operators
    - 54m 29s
    Noteworthy Patterns
    - 31m 32s


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