Please enable Javascript, which is required for this site.
sqlserver-tqpq

SQL Server: Troubleshooting Query Plan Quality Issues

Learn how to identify, diagnose, and prevent problems where SQL Server chooses the incorrect query plan for your critical queries, applicable to developers, DBAs, and anyone responsible for SQL Server, from SQL Server 2005 onwards

Authored by: Joe Sack
Duration: 2h 20m
Level: Intermediate
Released: 1/11/2013
Features: Closed captions
Course Rating:
You are currently not signed in. Please sign in to access subscriber-only content.
Currently using:  {{getCurrentPlayerName()}}  [Change]
expand all | collapse all Progress Duration
This module is unavailableCourse Introduction
 You have not watched this Module. 00:01:44
Course Introduction
You have not watched this Clip. 01:05
Course Structure
You have not watched this Clip. 00:39
This module is unavailableWhy Query Plan Quality Matters
 You have not watched this Module. 00:34:06
Module Introduction
You have not watched this Clip. 01:00
Which is the 'Good' Plan?
You have not watched this Clip. 02:57
Cardinality Estimates
You have not watched this Clip. 01:49
Costing and Plan Quality
You have not watched this Clip. 01:10
Operator Cost (1)
You have not watched this Clip. 01:03
Operator Cost (2)
You have not watched this Clip. 00:33
Operator Cost (3)
You have not watched this Clip. 01:33
Demo: Operator Cost
You have not watched this Clip. 07:43
Operator Memory
You have not watched this Clip. 01:12
Memory Operators
You have not watched this Clip. 01:42
Under-estimates and Spills
You have not watched this Clip. 01:13
Demo: Under-estimates and Spills
You have not watched this Clip. 04:01
Over-estimates and Concurrency
You have not watched this Clip. 01:26
Demo: Over-estimates and Concurrency
You have not watched this Clip. 03:33
Impacted Query Optimizer Decisions
You have not watched this Clip. 02:25
Excessive Resource Consumption
You have not watched this Clip. 00:46
This module is unavailableIdentifying Query Plan Quality Issues
 You have not watched this Module. 00:19:43
Module Introduction
You have not watched this Clip. 00:37
Estimated Query Execution Plan
You have not watched this Clip. 01:00
Actual Query Execution Plan
You have not watched this Clip. 00:55
Capturing an Actual Plan
You have not watched this Clip. 01:22
Demo: Capturing an Actual Plan
You have not watched this Clip. 02:22
SQL Sentry Plan Explorer
You have not watched this Clip. 01:00
Demo: SQL Sentry Plan Explorer
You have not watched this Clip. 02:00
SQL Server 2012 Supplemental Information
You have not watched this Clip. 01:37
Demo: Inaccurate Cardinality Estimate Event Capture
You have not watched this Clip. 02:50
Demo: ConvertIssue Plan Attributes
You have not watched this Clip. 02:03
Demo: Row Count Statistics in sys.dm_exec_query_stats
You have not watched this Clip. 03:57
This module is unavailableQuery Plan Quality Patterns and Resolutions
 You have not watched this Module. 01:24:54
Module Introduction
You have not watched this Clip. 00:33
Before Jumping In...
You have not watched this Clip. 01:26
Issue Prioritization
You have not watched this Clip. 01:01
Missing or Stale Statistics (1)
You have not watched this Clip. 01:51
Demo: Checking sys.databases
You have not watched this Clip. 00:56
Demo: Checking sys.stats and sp_helpstats
You have not watched this Clip. 01:28
Demo: Resolving NO_RECOMPUTE Issues
You have not watched this Clip. 05:02
Missing or Stale Statistics (2)
You have not watched this Clip. 01:26
Demo: Checking STATS_DATE
You have not watched this Clip. 01:40
Demo: Manual Statistics Updates
You have not watched this Clip. 06:20
Demo: Using Trace Flag 2371
You have not watched this Clip. 05:52
Sampling Issues
You have not watched this Clip. 01:44
Demo: Using DBCC SHOW_STATISTICS
You have not watched this Clip. 03:05
Demo: Using sys.dm_db_stats_properties
You have not watched this Clip. 02:18
Demo: Using FULLSCAN Manual Statistics Updates
You have not watched this Clip. 03:59
Demo: Creating Filtered Statistics
You have not watched this Clip. 02:55
Demo: Filtered Statistics Threshold Update Problem
You have not watched this Clip. 04:35
Hidden Column Correlation
You have not watched this Clip. 01:16
Demo: Hidden Column Correlation
You have not watched this Clip. 07:39
Comparison of Intra-Table Columns
You have not watched this Clip. 00:55
Demo: Comparison of Intra-Table Columns
You have not watched this Clip. 01:21
Table Variable Usage
You have not watched this Clip. 00:48
Demo: Table Variable Usage
You have not watched this Clip. 02:02
Scalar and MSTV UDFs
You have not watched this Clip. 01:24
Demo: MSTV UDFs
You have not watched this Clip. 02:27
Parameter Sniffing
You have not watched this Clip. 01:39
Demo: Parameter Sniffing
You have not watched this Clip. 03:11
Implicit Data Type Conversion Issues
You have not watched this Clip. 01:10
Complex Predicates
You have not watched this Clip. 01:00
Demo: Complex Predicates
You have not watched this Clip. 02:11
Query Complexity
You have not watched this Clip. 02:06
Demo: Query Complexity
You have not watched this Clip. 02:44
Hints
You have not watched this Clip. 01:03
Demo: Hints
You have not watched this Clip. 02:46
Distributed Queries
You have not watched this Clip. 01:11
Query Optimizer Bugs
You have not watched this Clip. 00:56
Course Summary
You have not watched this Clip. 00:54