Post reply

SQL Server:Buffer Manager (Target Pages) higher than (Total Pages)

  • July 22, 2011 at 7:03 am

    #254151

    Hi,

    I am currently monitoring a server and have discovered that

    SQL Server:Buffer Manager (Target Pages) is 28160000 and

    SQL Server:Buffer Manager (Total Pages) is 6623872

    Where can I investgate what is causing Target Pages to be more than 4 times greater than Total pages?

    Any possible ways of resolving this?

    Thanks

  • July 22, 2011 at 1:11 pm

    #1357263

    If you search on this subject, you'll likely find those that say that target needs to be less than total. My understanding is that, if total is less than target, you're ok.

    http://www.sql-server-performance.com/2005/performance-monitor-memory-counter/

  • July 27, 2011 at 4:26 am

    #1359042

    Hi Chuck,

    Thanks for your reply. I thought that if the Target pages was higher than Total Pages than this suggested external memory pressure.

    There is no external memory pressure anymore on the server but yet the Target Pages and Total Pages values remain the same.

    Should I restart the services or server to clear out these values?

    Thanks,

    George

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply