none
stolen pages and total pages

    Question

  • We have a SQL Server instance, max memory set to 10gb on a 12gb (VM) server, and these are the numbers I get from the buffer manager, with the plan cache thrown in for good luck.  Does that seem about right - and isn't that an awful lot of stolen pages?

    Thanks.

    Josh

    object_name

    counter_name

    instance

    pages

    mbytes

    SQLServer:BufferManager 

    Freepages

      

    6,053

       49.6

    SQLServer:BufferManager

    Totalpages

     

    807,638

       6,616.2

    SQLServer:BufferManager

    Databasepages 

      

       407,600

    3,339.1

    SQLServer:BufferManager

    Stolenpages

      

    393,985

    3,227.5

    SQLServer:PlanCache

    CachePages

     _Total

    353,065

    2,892.3


    • Edited by JRStern Thursday, February 07, 2013 8:19 PM
    Thursday, February 07, 2013 7:37 PM

Answers

All replies