The Bit Bucket (Greg Low): IDisposable

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

Whitepaper: Plan Caching and Recompilations in SQL Server 2012

Hi Folks,

Over the last year, I've been working on an update to the whitepaper Plan Caching in SQL Server 2008 as a background task.

A great group of reviewers have been involved at various stages during the process. Thank you to Paul White, Andrew Kelly, Kalen Delaney, and Rubén Garrigós from the SQL community, along with Leigh Stewart and Jack Li from the SQL Server product team for sharing your knowledge and ideas.

Gail Erikson from the SQL documentation team let me know today that the latest version Plan Caching and Recompilation in SQL Server 2012 is now available:

http://msdn.microsoft.com/en-us/library/dn148262.aspx

Enjoy!

Published Saturday, March 16, 2013 2:39 PM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

	The Bit Bucket (Greg Low): IDisposable said: Hi Folks, I posted a day or so back about the whitepaper on plan caching and recompilation being published. March 19, 2013 2:13 AM
	KKline said: Awesome stuff, Greg! I can't wait to start promoting it. =^) March 19, 2013 10:49 AM
	Gatej Alexandru said: Hello, I saw your article and is a very nice one. Congrats! I have one question: This formula is Cost = I/O cost + context switch cost (a measure of CPU cost) + memory cost is not the same with the value of original_cost or current_cost of DMV sys.dm_os_memory_cache_entries. Can you please help me with the difference? I have also an example I ran uspGetManagerEmployees from AdventureWorks db and is not the same. Thanks. April 7, 2013 10:32 AM
	Greg Low said: Hi Gatej, When you say that it's not the same, I'm not following what you're referring to exactly. April 25, 2013 9:11 PM