SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Classes
About Us
Login / Register
Subscribe RSS Feed 

Confio Ignite

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.

Duration:
2 mins 28 secs
Skill Level:
100
Rating:
4.28 out of 5
Publish Date:
January 27, 2009
Monitoring Exec Cache in SQL Server - Part 1 Watch Video Now  Watch it later!
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Jonathan Kehayias
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:/...

References



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



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions