SQL Server Performance Forum – Threads Archive
Amount of Memory Usage
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/
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.
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/
why do you consider this a problem
sql is supposed to use memory to reduce disk io
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/
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
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/
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
]]>