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

SQL Server: Common Performance Issue Patterns

Learn how to recognize and diagnose more than 35 types of performance problems that can affect SQL Server; applicable to developers, DBAs, and anyone responsible for SQL Server, from SQL Server 2005 onwards

Authored by: Joe Sack
Duration: 2h 37m
Level: Intermediate
Released: 11/21/2012
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:03:28
Course Introduction
You have not watched this Clip. 01:15
Course Structure
You have not watched this Clip. 02:13
This module is unavailableHigh-Level Issue Patterns
 You have not watched this Module. 00:15:12
Module Introduction
You have not watched this Clip. 01:03
Vendor Bias (1)
You have not watched this Clip. 01:04
Vendor Bias (2)
You have not watched this Clip. 02:01
Expertise Traps
You have not watched this Clip. 01:16
Missing Data
You have not watched this Clip. 00:59
Incomplete Data
You have not watched this Clip. 01:07
Lack of Troubleshooting Methodology
You have not watched this Clip. 01:04
Troubleshooting Downstream Issues
You have not watched this Clip. 00:56
Ignoring Capacity Considerations (1-2)
You have not watched this Clip. 01:35
Ignoring Capacity Considerations (3)
You have not watched this Clip. 01:18
Failure to Enforce Standards
You have not watched this Clip. 01:15
Missing Change Control
You have not watched this Clip. 01:34
This module is unavailableI/O Patterns
 You have not watched this Module. 00:23:32
Module Introduction
You have not watched this Clip. 00:41
Inadequate I/O Paths (1)
You have not watched this Clip. 01:11
Inadequate I/O Paths (2)
You have not watched this Clip. 01:52
Demo: Inadequate I/O Paths
You have not watched this Clip. 07:29
I/O-Intensive Execution Plans (1)
You have not watched this Clip. 00:57
I/O-Intensive Execution Plans (2)
You have not watched this Clip. 01:09
Demo: I/O-Intensive Execution Plans
You have not watched this Clip. 07:38
Aggressive Checkpoint Activity
You have not watched this Clip. 01:22
Collocation with Bad Neighbors
You have not watched this Clip. 01:13
This module is unavailableConcurrency Patterns
 You have not watched this Module. 00:21:41
Module Introduction
You have not watched this Clip. 00:48
Long-Term Blocking
You have not watched this Clip. 02:37
Demo: Long-Term Blocking
You have not watched this Clip. 06:17
Lock Escalation
You have not watched this Clip. 02:03
Accessing Objects Inconsistently
You have not watched this Clip. 00:51
Demo: Accessing Objects Inconsistently
You have not watched this Clip. 02:18
Forgotten Side-effects
You have not watched this Clip. 01:00
Demo: Forgotten Side-effects
You have not watched this Clip. 04:40
Hint Misuses and Restrictive Isolation Levels
You have not watched this Clip. 01:07
This module is unavailableMemory Patterns
 You have not watched this Module. 00:23:20
Module Introduction
You have not watched this Clip. 00:32
Memory Pressure (1)
You have not watched this Clip. 01:06
Memory Pressure (2)
You have not watched this Clip. 02:04
Memory Pressure (3)
You have not watched this Clip. 01:36
Demo: Memory Pressure
You have not watched this Clip. 08:25
Query Execution Memory Issues (1)
You have not watched this Clip. 01:07
Query Execution Memory Issues (2)
You have not watched this Clip. 01:46
Demo: Query Execution Memory Issues
You have not watched this Clip. 06:44
This module is unavailableTempdb Patterns
 You have not watched this Module. 00:13:30
Module Introduction
You have not watched this Clip. 00:36
Allocation Page Contention (1)
You have not watched this Clip. 00:46
Allocation Page Contention (2)
You have not watched this Clip. 01:23
Demo: Allocation Page Contention
You have not watched this Clip. 04:01
Row Versioning Overhead
You have not watched this Clip. 00:54
Demo: Row Versioning Overhead
You have not watched this Clip. 03:44
Collocation with High I/O Databases
You have not watched this Clip. 01:11
Query Workspace Overhead
You have not watched this Clip. 00:55
This module is unavailableCPU Patterns
 You have not watched this Module. 00:30:34
Module Introduction
You have not watched this Clip. 00:38
External CPU Pressure
You have not watched this Clip. 01:14
High Privileged Time
You have not watched this Clip. 02:02
User-Time SQL Server CPU Time (1)
You have not watched this Clip. 01:37
User-Time SQL Server CPU Time (2)
You have not watched this Clip. 01:06
Demo: User-Time SQL Server CPU Time
You have not watched this Clip. 03:31
I/O Correlated High CPU
You have not watched this Clip. 00:57
Demo: I/O Correlated High CPU
You have not watched this Clip. 02:37
Excessive Compilation and Recompilation (1)
You have not watched this Clip. 00:52
Excessive Compilation and Recompilation (2)
You have not watched this Clip. 02:11
Demo: Excessive Compilation and Recompilation
You have not watched this Clip. 02:39
Observer Overhead
You have not watched this Clip. 02:37
Demo: Observer Overhead
You have not watched this Clip. 03:20
Uninvited Parallelism
You have not watched this Clip. 02:29
Demo: Uninvited Parallelism
You have not watched this Clip. 02:44
This module is unavailableApplication Design Patterns
 You have not watched this Module. 00:13:48
Module Introduction
You have not watched this Clip. 00:38
Slow Fetches
You have not watched this Clip. 02:13
Demo: Slow Fetches
You have not watched this Clip. 02:48
Needless Queries
You have not watched this Clip. 02:12
Over and Under-Architecture (1)
You have not watched this Clip. 01:39
Over and Under-Architecture (2)
You have not watched this Clip. 01:23
Boil-the-Ocean Modules (1)
You have not watched this Clip. 01:22
Boil-the-Ocean Modules (2)
You have not watched this Clip. 01:33
This module is unavailablePlan Quality Patterns
 You have not watched this Module. 00:11:56
Module Introduction
You have not watched this Clip. 00:38
Cardinality Estimate Issues
You have not watched this Clip. 01:52
Demo: Cardinality Estimate Issues
You have not watched this Clip. 04:07
Opaque Operations and Hidden Costs
You have not watched this Clip. 01:18
Demo: Opaque Operations and Hidden Costs
You have not watched this Clip. 03:22
Course Summary
You have not watched this Clip. 00:39