 Report Abuse |
Plan cache and optimizing for adhoc workloads
4/17/2015 4:31:32 PM
Plan cache and optimizing for adhoc workloads
mentioned that servers receiving a lot of dynamic constructs (typically those generated by client SQL apps/ORMs/LINQ, etc.) can start to consume too much plan cache and have problems with “single-use plans” in my last post titled: Statement execution and why you should use stored procedures. I also mentioned that SQL Server 2008 has an option/feature specifically to help reduce the bloat on the plan cache by only storing a query plan hash the first time a plan is created.
First – let’s check to see how your plan cache is currently allocated:
......................................................
http://www.sqlskills.com/blogs/kimberly/plan-cache-and-optimizing-for-adhoc-workloads/
For Reference.
|