Overview
Explore SQL Server's plan cache in this comprehensive conference talk from PASS Data Community Summit. Discover techniques for managing and analyzing the plan cache to identify performance issues, even without prior tracing setup. Learn about memory management, tools for examining cached plans, and methods to detect potentially problematic query operators. Gain valuable insights into your SQL Server's performance history and acquire the knowledge needed to pinpoint areas for optimization. Equip yourself with proactive strategies to enhance database performance by understanding what has occurred in your SQL Server environment.
Syllabus
What Happened? Exploring the Plan Cache - Kalen Delaney
Taught by
PASS Data Community Summit