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

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.

Steven Kwong on 1/14/2011

This is interesting. Very useful and will be effective.

Lonnie Meinke on 12/19/2011

A 15 second background on the cache and SQL Server's use of it would have been helpful.

Jack Hellmuth on 12/19/2011

I am getting an error on the 'Monitoring Exec Cache.sql' - Incorrect syntax near '.' I am not seeing the problem and neither is IntelliSense.

Anil Babu on 12/19/2011

good one thanks

Jonathan on 12/20/2011

Great content, Thanks.

Shashank Banerjea on 12/20/2011

The author explained the issue and how to detect it. Vital tool to determine now performing query. Looking foward to Part 2.

Randall Price on 12/21/2011

This is great information but I would have liked a little more background on the procedure cache. The demo was good but a little fast. I did not get enough time to look over the results and code while the demo was going on.

Kuljit Singh on 2/2/2012

Good work.Keep it up.

Kuljit Singh on 2/2/2012

Can you share the code or email it or provide some download.