Improve SQL Server Performance by Looking at Plan Cache (Part 3)
Starting in SQL Server 2008, you can examine the plan cache to quickly identify plans that are similar and may be optimized. Learn how.
Read MoreMost Popular Plan Cache
Improve SQL Server Performance by Looking at Plan Cache (Part 2)
Examining the SQL Server plan cache can help you to quickly identify plans that need tuning, including: plans that have missing indexes, plans that are performing key lookup and plans with implicit conversion warnings.
Read MoreImprove SQL Server Performance by Looking at Plan Cache (Part 1)
The SQL Server plan cache stores details on statements that are being executed over time, and you can use it to investigate performance issues and look for opportunities to improve performance. Learn how.
Read MoreSQL Server Plan Caching and Recompilation–Plan Cache
To find performance issues caused by long lookup times, you can look into the contents of the SQL Server DMV sys.dm_os_memory_cache_hash_tables. Learn more.
Read More