Refer to our video blog , to know the important role that "Procedure Cache" can play in increasing your application and SQL server performance.
Procedure Cache, main goal is to cache the query plans and allow its reuse and thus minimize the compile time and improve the performance.
This blog will provide you detailed information about some of the below mentioned topics:-
- What is Procedure Cache?
- Types of Cached Objects
- Structure of the Procedure Cache
- Procedure Cache And Memory
- Non- Cached Plans and Zero Cost Plans
For better quality of the video , please click on the link: - https://channel9.msdn.com/posts/Procedure-Cache-Part-II
Presented By:- Niraj P mehta, Senior Support Enigneer, Microsoft GTSC
Reviewed By: - Rishi Maini,Support Escalation Engineer,Microsoft GTSC
Pranab Mazumdar,Support Escalation Engineer,Microsoft GTSC