SQL Server Performance

SQLServer:Memory Manager: Total Server Memory (KB)

Discussion in 'Performance Tuning for DBAs' started by MartinSmithh, Oct 7, 2006.

  1. MartinSmithh New Member

    Hi,

    I've read the advice herehttp://www.sql-server-performance.com/performance_monitor_counters_sql_server.asp on this site concerning
    Total Server Memory and Target Server Memory but I am confused by the author's conclusion that Total Server Memory (KB) counter should be less than the SQLServer:Memory Manager: Target Server Memory.

    Is this correct. If so why? (I would have thought it was the opposite way round)



    ***************** Full Tip Text is pasted below for reference *****************


    Consider watching these two counters: SQLServer:Memory Manager: Total Server Memory (KB) and SQLServer:Memory Manager: Target Server Memory (KB). The first counter, SQLServer:Memory Manager: Total Server Memory (KB), tells you how much the mssqlserver service is currently using. This includes the total of the buffers committed to the SQL Server BPool and the OS buffers of the type "OS in Use".

    The second counter, SQLServer:Memory Manager: Target Server Memory (KB), tells you how much memory SQL Server would like to have in order to operate efficiently. This is based on the number of buffers reserved by SQL Server when it is first started up.

    If, over time, the SQLServer:Memory Manager: Total Server Memory (KB) counter is less than the SQLServer:Memory Manager: Target Server Memory (KB) counter, then this means that SQL Server has enough memory to run efficiently. On the other hand, if the SQLServer:Memory Manager: Total Server Memory (KB) counter is more or equal than the SQLServer:Memory Manager: Target Server Memory (KB) counter, this indicates that SQL Server may be under memory pressure and could use access to more physical memory. [7.0, 2000] Updated 5-25-2005

  2. Chappy New Member

    Agreed, this doesnt make any sense.<br />The tip itself is valid, but Id disregard the authors use of Target vs Total, it looks like hes got a bit confused <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />

Share This Page