We have a new SQL Server 2008 R2 implementation running on a Windows 2008 R2 64-bit virtual server w/ 12GB RAM.
We've moved only 1 database to this system so far and although it is a highly accessed DB, it ran quite nicely on a Windows 2003 32bit system w/ 3 GB RAM and SQL 2000.
After a fresh boot, the memory utilization is practically nil, however it slowly grows over a week until it is nearly maxed out. The process eating up the memory is sqlservr.exe.
So, why would the memory be so high and why would it grow slowly over time. (I've been reading a bit on the Address Windowing Extension (AWE) though I'm not sure this is or isn't what we're experiencing.)
Thanks for your help!
View Complete Post