Plan cache flush when changing page verify option inconsistent with documentation - by Michael Decuir

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 779263 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 2/14/2013 4:11:42 PM
Access Restriction Public


When changing the page verify option for a database, all execution plans in the plan cache associated with that database are flushed.  Books online indicates several ALTER DATABASE SET options which can cause a plan cache flush.  This setting is not among those listed.

The documentation for this behavior should be consistent with the actual behavior.
Sign in to post a comment.
Posted by Rick [MSFT] on 2/15/2013 at 1:58 PM
I have added PAGE_VERIFY. Thank you for pointing this out. It will take a couple of weeks to appear in MSDN for SQL Server 2012. AS much as several months for SQL Server 2008 R2 documentation.