SQL Server Performance

Total Server Memory vs. Target Server Memory

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by icata, Feb 6, 2007.

  1. icata New Member

    Contrary to my believe that for a good SQL Server run the two should be equal, in the last couple of days I found two articles that advice that Total Server Memory should be less then Target Server Memory

    http://download.microsoft.com/downl...31282b04d/Performance_Tuning_Waits_Queues.doc

    "If Total Server Memory is well below Target Server Memory at steady state, it tells you that the server is not experiencing memory pressure."

    h71028.www7.hp.com/ERC/downloads/4AA0-2948ENW.pdf

    "Total Server Memory < 80 percent Target Server Memory "

    Is that right? If you think yes, why?

    Best Regards

  2. joechang New Member

    Tom made a reasonable & true statement
    but he is not saying what the value should be

    the HP paper is of questionable technical competence

    in any case, do not try to over interpret what counter values should be
    the real metrics are
    1. is your server having performance problems
    2. could performance be improved
    etc

    a simple counter value does not answer the important question

  3. Luis Martin Moderator

    Is sql server dedicated?
    The configuration memory is dynamically?


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



Share This Page