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 currently employed as a Principal Consultant and Trainer for SQLskills, one of the best-known and most respected SQL Server training and consulting companies in the world. Jonathan is a SQL Server MVP and one of the few Microsoft Certified Masters for SQL Server 2008, outside of Microsoft. Jonathan frequently blogs about SQL Server, presents sessions at PASS Summit, SQLBits, S...

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

Steven Kwong on 1/14/2011

Very good follow up to part 1.

Jonathan on 12/20/2011

Could be very useful. Thanks.

A4A72D151B on 12/20/2011

needed to see the other one first but I get it, sorta...

Dan on 12/20/2011

Need to explain why one was int and the other was varchar. How could that happen?

Andrew on 12/20/2011

Good information, not the best presentation.

Paul on 12/20/2011

The quality jumped

Dave Bennett on 12/20/2011

Excellent technique that I was unaware of. I can see multiple applications for it. Thanks!

AEE49878AC on 12/21/2011

Excellent, did not know about plan guides or templates.

Randall Price on 12/21/2011

Excellent follow-up for part 1.

Kuljit Singh on 2/2/2012

Good work. Keep it up.