Results 1 to 5 of 5
  1. #1
    Join Date
    May 2006
    Posts
    5

    Unanswered: Performance monitor -- Buffer cache object

    Hello,
    Does the performance counter Buffer cache object refer to Data cache and procedure cache or just refers to Data cache???

    I was of the opinion that Buffer cache means data cache and Plan cache means procedure cache. Can someone throw some light???

    Regards

    Jaideep

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    SQLServer:Buffer Manager-> Buffer cache hit ratio is a measure of how well the data pages alone are being hit. There is a separate category for the Procedure Cache (SQLServer: Cache Manager).

  3. #3
    Join Date
    May 2006
    Posts
    5
    Thanks for your reply. is there a way to monitor the size of the data cache and procedure cache seperately. Buffer cache is a very confusing term. Does it refer to Data cache which holds all recently accessed data as well as pinned tables or does it refer to procedure cache which holds all recently accessed compiled query plans. I have tried dbbc showmemory which i think replaced dbcc memusage from the sybase days. Even there there is no clear distinction between data cache and procedure cache. I am coming from a sybase background where we can configure both cache's independently from the total memory pool.

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Look into the Buffer Manager->Data Pages and Buffer Manager->Procedure Cache counters.

  5. #5
    Join Date
    May 2006
    Posts
    5
    This means that buffer cache is actually the memory structure as a whole. Data cache and procedure cache and other cache requirements for work and hash tables are collectively referred to as buffer cache. Am I right???

    Jaideep

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •