Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
InfraDBA
Starting Member
38 Posts |
 Posted - 2011-06-15 : 05:12:33
|
| One of the common problems for SQL server is whenever it acquires memory it doesn't release it unless pressure from the OS.I saw this behavior in one of our environment wherein it consumed almost 28 GB space although buffer usage was not much.Now the question is as soon as I tried to analyse it via resource monitor resource monitor won't show the actual memory used by SQL.It shows something different(the value is less as compared to the actual usage).Can you explain this behavior please? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-06-15 : 06:12:37
|
| Task manager doesn't show locked pages. Use perfmon - total server memory counter. (SQL Memory manager I think)p.s. the memory pattern you describe is not a problem. It's intended behaviour.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Virtual Memory