|
by kimberly.nospam@nospam.sqlskills.com (kltripp) via Kimberly L. Tripp on 4/22/2010 5:50:00 PM
I mentioned that servers receiving a lot of dynamic constructs (typically those generated by client SQL generaters/ORM/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.
Fi
... [ read more ]
|
