Plan Caching in SQL Server 2008
Greg Low, has published a whitepaper Plan Caching in SQL Server 2008, it's an update of the whitepaper "Batch compilation, Recompilation and Plan Caching Issues in SQL Server 2005" by Arun Marathe, targeted at SQL Server 2008.
Summary: This paper explains how SQL Server 2008 allocates memory for plan caching, how query batches are cached and suggests best practices on maximizing reuse of cached plans. It also explains scenarios in which batches are recompiled, and gives best practices for reducing or eliminating unnecessary recompilations and for minimizing plan cache pollution.
http://msdn.microsoft.com/en-us/library/ee343986.aspx
CU
tosc
| Print article | This entry was posted by Torsten Schuessler on 2009-08-04 at 08:30:53 . Follow any responses to this post through RSS 2.0. |
http://www.insidesql.org/blogs/htsrv/trackback.php?tb_id=332
miscellaneous °-°
-
-
backup «best practices» books «cumulative update» datetime dmv faq humor index indexoptimize integrity links loginproperty maintenance «ms sql server 2008» mysql performance php profiler «reporting services» reviews serverproperty «service pack» «service pack 3» sharepoint sp_msforeachdb «sql pass» «sql server» «sql server 2005» «sql server 2008 r2» «sql server builds» sqlcat «sqlpass franken» ssms ssmstoolspack t-sql «technical note» tools troubleshooting whitepapers
XML FeedsSchlagwort-Wolke
backup «best practices» books «case study» ctp «cumulative update» datetime dmv ebook exams faq humor index indexoptimize integrity kb learning links loginproperty maintenance «ms sql server 2008» mysql performance php profiler «reporting services» reports reviews serverproperty «service pack» «service pack 3» sharepoint sp_msforeachdb «sql 2008» «sql pass» «sql server» «sql server 2005» «sql server 2008 r2» «sql server builds» sqlcat «sqlpass franken» sqlsrv ssms ssmstoolspack t-sql «technical note» tools training troubleshooting whitepapers