Microsoft KB Archive/825728

= BUG: SQL Server Books Online Incorrectly States That the Age Field of a Query Plan Is Incremented by Compilation Cost Factor =

Article ID: 825728

Article Last Modified on 11/26/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-





SYMPTOMS
The &quot;Aging Execution Plans&quot; section in the &quot;Execution Plan Caching and Reuse&quot; topic of SQL Server Books Online incorrectly states that each time a query plan that resides in the procedure cache is referenced by a connection, the age field of the query plan object is incremented by the compilation cost factor.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
The &quot;Aging Execution Plans&quot; section states that Microsoft SQL Server 2000 ages old, unused execution plans out of the procedure cache when space is required. Each query plan and execution context has an associated cost factor that indicates how expensive the structure is to compile. These data structures also have an age field. The &quot;Aging Execution Plans&quot; section then incorrectly states that each time the object is referenced by a connection the age field is incremented by the compilation cost factor.

However, when the object is referenced by a connection, SQL Server 2000 resets the age factor of a query plan to the cost factor. For example, if a query plan has a cost factor of 8, the age factor of the query plan is reset to 8 every time the query plan referenced for reuse. Therefore, even though the query is referenced two times, the age factor is set to 8.

Keywords: kbbug kbcaching kbstoredproc kbhelpfile kbquery KB825728

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.