none
Performance Counter SQLServer:Cache Manager:Cache Pages (Execution Contexts) = 4294967295

    Question

  • Performance Counter

     

    SQLServer:Cache Manager:Cache Pages (Execution Contexts) = 4294967295

     

    What this might mean?

     

    It overflows, but what it might mean ....

    Thursday, October 07, 2010 7:52 AM

Answers

  • The Number of Cache Pages overflows. What this might mean?

    Each user that is currently executing the query has a data structure that holds the data specific to their execution, such as parameter values. This data structure is referred to as the execution context. The execution context data structures are reused. If a user executes a query and one of the structures is not being used, it is reinitialized with the context for the new user.

    If cached pages of execution context overflows, it means it used up the memory (procedure cache in the buffer pool). If I remember correctly, the max size of procedure cache is 2GB.


    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by dmfr Wednesday, October 27, 2010 7:10 AM
    Wednesday, October 27, 2010 1:16 AM
    Moderator

All replies

  • Execution Contexts
    Friday, October 08, 2010 5:55 AM
  • Execution Contexts


    From Books Online:

    From a query plan, an execution context is derived. Execution contexts hold the values needed for a specific execution of a query plan. Execution contexts are also cached and reused. Each user concurrently executing a batch will have an execution context that holds data (such as parameter values) specific to their execution. You could find more information at Plan Caching in SQL Server 2008 (http://msdn.microsoft.com/en-us/library/ee343986(SQL.100).aspx).

    Hope this helps.

    Thanks,
    Chunsong


    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Wednesday, October 13, 2010 8:51 AM
    Moderator
  • The Number of Cache Pages overflows. What this might mean?
    Wednesday, October 13, 2010 11:44 AM
  • ........???.........
    Monday, October 18, 2010 7:16 AM
  • ---???----
    Tuesday, October 26, 2010 11:32 AM
  • The Number of Cache Pages overflows. What this might mean?

    Each user that is currently executing the query has a data structure that holds the data specific to their execution, such as parameter values. This data structure is referred to as the execution context. The execution context data structures are reused. If a user executes a query and one of the structures is not being used, it is reinitialized with the context for the new user.

    If cached pages of execution context overflows, it means it used up the memory (procedure cache in the buffer pool). If I remember correctly, the max size of procedure cache is 2GB.


    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by dmfr Wednesday, October 27, 2010 7:10 AM
    Wednesday, October 27, 2010 1:16 AM
    Moderator