principlesqlMinor
SQL Server Plan Guide vs Plan Freezing
Viewed 0 times
sqlguideplanfreezingserver
Problem
I am bit confused with terminology as official Microsoft SQL Server documentation including BOL refers to plan guide the one you create using sp_create_plan_guide proc. Does plan freezing is same thing or slightly different?. Reading Erland's great article here
There are two ways to set up plan guides, a general way, and a
shortcut which is also known as plan freezing. General plan guides
were introduced in SQL 2005, whereas plan freezing was added in SQL
2008.
I am reading plan freezing is when you create guide using sp_create_plan_guide_from_handle
Seeking a clarification on terminology being used, does plan guide and plan freezing is the same thing or they refer to slightly different way to stick the execution plan in the cache?
There are two ways to set up plan guides, a general way, and a
shortcut which is also known as plan freezing. General plan guides
were introduced in SQL 2005, whereas plan freezing was added in SQL
2008.
I am reading plan freezing is when you create guide using sp_create_plan_guide_from_handle
Seeking a clarification on terminology being used, does plan guide and plan freezing is the same thing or they refer to slightly different way to stick the execution plan in the cache?
Solution
Yes, that is my understanding as well, and this post helps provide some examples for you to review.
Plan guides (plan freezing) in SQL Server 2005/2008
Plan guides (plan freezing) in SQL Server 2005/2008
Context
StackExchange Database Administrators Q#31170, answer score: 4
Revisions (0)
No revisions yet.