SQL Server Performance

Permon Counters .. free buffers and total server memory

Discussion in 'Performance Tuning for DBAs' started by Simon_L, Oct 20, 2008.

  1. Simon_L New Member

    Again a moment when all is running smoothly so time to reflect / brush up on knowledge etc etc

    I have a couple of questions regarding perfmon ,,,

    Did I imagine it or did SQLServer: buffer Manager used to have a counter called Free buffers ??

    and

    Total Server Memory .. is this not the same as overall server memory ??


    thank you
    Simon_L, Oct 20, 2008
    #2

  2. satya Moderator

    Are you referring to Object: - SQL Server:Buffer Manager Counter: - Free pages and coming to other one you can find explicit counters given to check the SQL Server memory usage. SQL Server: Memory Manager: Total Server Memory counter can tell you the amount of dynamic memory the server is presently consuming. You can also look into:
    • SQL Server: Buffer Manager: Buffer cache hit ratio
    • SQL Server: Buffer Manager: Page Life Expectancy
    • Process: Working Set
    satya, Oct 20, 2008
    #3

  3. Simon_L New Member

    thanks for the reply , much appreciated :) .. especially clarifiying total server memory
    no not Free pages (unless it has been renamed ?)
    SQL Server Buffer Manager counters Free buffers = number of free bufffers availble
    source http://doc.ddart.net/mssql/sql70/perfmon_6.htm
    best wishes
    Simon
    Simon_L, Oct 21, 2008
    #4

Share This Page