Monitoring Exec Cache in SQL Server - Part 1

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:/...

DavidB on 7/16/2009

Great job Jonathan!

G Bryant McClellan on 7/16/2009

Can you share the code?

G Bryant McClellan on 7/16/2009

Doh! Found it. Thanks

Nagarjuna Reddy on 7/16/2009

Voice is not interesting and is not dynamic though explaination was good though.

Dinesh Pendlimarri on 7/17/2009

Bingo...gr8 piece of info.

dibmaz on 7/17/2009

Good job

eirc on 7/21/2009

too short

Tonci on 10/19/2009

Great explanation, but I thought you were going to show sql profiler or performance monitor.

Cordelia on 5/12/2010

It would be really helpful if the viewers have access to the queries used in the video.