Welcome Guest
Login Register
 
Plan cache and optimizing for adhoc workloads
 
0 Reply's, Recent Post by Tech on 4/17/2015 4:31:32 PM
   

Previous Thread     Next Thread

Tech
9 Points
51 Posts
Guest Reply      Reply            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.
Post Your Comment        
   Previous Thread     Next Thread
Guest Reply