SQL Server Performance

Amount of Memory Usage

Discussion in 'Performance Tuning for Hardware Configurations' started by dineshasanka, Dec 14, 2006.

  1. dineshasanka Moderator

    Amount of memory usage for sqlserver.exe is increasng. I checked all the emeory counters they are fine.
    This Pc has replication publisher. But we have same configuration with no issues?
    what are your thoughts on this

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  2. satya Moderator

    KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;321363 fyi on the memory configuration, if you have missed any (Im sure you will not).

    The reasons and expereince of high memory usage could cause due to when SQL Server reads data from disk, it saves the data in the cache,because memory access is much less expensive than disk access. Thus, the strategy is keep as much as possible in cache.

    So you need to consider the data volume here in order to assess the replication publisher has this issue.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  3. dineshasanka Moderator

    thanks for the information
    yes I cehcked that link. Howeer, I have same configuration which does not have this problem.

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  4. joechang New Member

    why do you consider this a problem
    sql is supposed to use memory to reduce disk io
  5. dineshasanka Moderator

    for two reasons.
    1It will increse like this and will come to the maximum meory fir server and server will hang.
    2 Why it is not hapening for same other configurations

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  6. joechang New Member

    hanging is caused by memory leaks which are actually virtual address space leaks, not memory leak, so increased physical memory usage is not an indication of this

    what is the difference in hw, configuration and usage
    you have provided almost no meaningful information to analyze
  7. dineshasanka Moderator

    sorry fo rthe less details.
    both configuration are same both have 1gb memeory with same configurations

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  8. joechang New Member

    this is still nearly no information
    how can you make an assessment that there is a problem based on this
    if some one else is to make an assessment, he must see the same information that you used to make this assessment

    what do you mean increasing?
    physical memory use cannot increase without bound
    what is paging rate

    why do you expect the memory to be the same between two systems
    is the db identical, in data content and usage

Share This Page