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: Troubleshooting Query Plan Quality Issues

Course Summary

There are many problems that can lower the performance of your workload and one of the most common is an incorrect query plan. Often the poor query plan is chosen because the cardinality estimate is wrong - the estimate by the query processor of how many

  • +

    Course Syllabus

    ● Course Introduction
        ◦ Course Introduction
        ◦ Course Structure
    ● Why Query Plan Quality Matters
        ◦ Module Introduction
        ◦ Which is the 'Good' Plan?
        ◦ Cardinality Estimates
        ◦ Costing and Plan Quality
        ◦ Operator Cost (1)
        ◦ Operator Cost (2)
        ◦ Operator Cost (3)
        ◦ Demo: Operator Cost
        ◦ Operator Memory
        ◦ Memory Operators
        ◦ Under-estimates and Spills
        ◦ Demo: Under-estimates and Spills
        ◦ Over-estimates and Concurrency
        ◦ Demo: Over-estimates and Concurrency
        ◦ Impacted Query Optimizer Decisions
        ◦ Excessive Resource Consumption
    ● Identifying Query Plan Quality Issues
        ◦ Module Introduction
        ◦ Estimated Query Execution Plan
        ◦ Actual Query Execution Plan
        ◦ Capturing an Actual Plan
        ◦ Demo: Capturing an Actual Plan
        ◦ SQL Sentry Plan Explorer
        ◦ Demo: SQL Sentry Plan Explorer
        ◦ SQL Server 2012 Supplemental Information
        ◦ Demo: Inaccurate Cardinality Estimate Event Capture
        ◦ Demo: ConvertIssue Plan Attributes
        ◦ Demo: Row Count Statistics in sys.dm_exec_query_stats
    ● Query Plan Quality Patterns and Resolutions
        ◦ Module Introduction
        ◦ Before Jumping In...
        ◦ Issue Prioritization
        ◦ Missing or Stale Statistics (1)
        ◦ Demo: Checking sys.databases
        ◦ Demo: Checking sys.stats and sp_helpstats
        ◦ Demo: Resolving NO_RECOMPUTE Issues
        ◦ Missing or Stale Statistics (2)
        ◦ Demo: Checking STATS_DATE
        ◦ Demo: Manual Statistics Updates
        ◦ Demo: Using Trace Flag 2371
        ◦ Sampling Issues
        ◦ Demo: Using DBCC SHOW_STATISTICS
        ◦ Demo: Using sys.dm_db_stats_properties
        ◦ Demo: Using FULLSCAN Manual Statistics Updates
        ◦ Demo: Creating Filtered Statistics
        ◦ Demo: Filtered Statistics Threshold Update Problem
        ◦ Hidden Column Correlation
        ◦ Demo: Hidden Column Correlation
        ◦ Comparison of Intra-Table Columns
        ◦ Demo: Comparison of Intra-Table Columns
        ◦ Table Variable Usage
        ◦ Demo: Table Variable Usage
        ◦ Scalar and MSTV UDFs
        ◦ Demo: MSTV UDFs
        ◦ Parameter Sniffing
        ◦ Demo: Parameter Sniffing
        ◦ Implicit Data Type Conversion Issues
        ◦ Complex Predicates
        ◦ Demo: Complex Predicates
        ◦ Query Complexity
        ◦ Demo: Query Complexity
        ◦ Hints
        ◦ Demo: Hints
        ◦ Distributed Queries
        ◦ Query Optimizer Bugs
        ◦ Course Summary


Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
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