Home Dashboard Directory Help
Search

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


Status: 

Resolved
 as Fixed Help for as Fixed


2
0
Sign in
to vote
Type: Bug
ID: 779263
Opened: 2/14/2013 4:11:42 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

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.
Details
Sign in to post a comment.
Posted by Microsoft 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.
Sign in to post a workaround.