Monitoring Exec Cache in SQL Server - Part 2

This video shows you how to monitor the size of the procedure cache in SQL Server by using the sys.dm_exec_cached_plans view.

Jonathan Kehayias is a SQL Server MVP with experience in Database Administrator and Development. He is currently the SQL Database Administrator for OSI Restaurant Partners in Tampa, FL. His primary passion is performance tuning, where he frequently rewrites queries for better performance and performs in depth analysis of index implementation and usage. His current projects include building http:/...

4B47653576 on 7/17/2009

woukd like the sql

Dinesh Pendlimarri on 7/17/2009

Maybe we could use more unravelling of dm views in few videos. Quite useful to know what system tables and views can help one achieve.

sqlrumble on 7/17/2009

Can you forward the T-SQL code?

dibmaz on 7/17/2009

Which the video was long with more dscriptive examples

Ravi Raj on 6/24/2010

good article

Ravi Raj on 6/24/2010

excellent video