Memory Usage

Hello Everybody,
We have a SQL SERVER installed on a Windows 2003 SERVER which has memory of
3.5 GB. We have configured SQL SERVER as a Dynamically Configure SQL SERVER
memory when we installed. Now when we check memory usage of SQL SERVER
sqlservr.exe is using a 1.7 GB of memory ? os just wondering is it normal ?
Pls let us know.
Its Normal if You have Memory more than 4 gb u can enable awe and set
max server memory to 3.5 to be allocated to sql and rest for the Os but
with less than 4 its better u leave it dynamically, check out the
Paging File configuration u can work around it and see if its
configured corrrectly.
Thanks,
Saradhi
|||Yes, it is normal. Sql will acquire memory as needed, but not release it,
even if no one is currently connected. This prevents memory thrashing and
allows caches to stay loaded.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"mvp" <mvp@.discussions.microsoft.com> wrote in message
news:426DDB91-F9A8-4E2F-9545-6978AA570E9C@.microsoft.com...
> Hello Everybody,
> We have a SQL SERVER installed on a Windows 2003 SERVER which has memory
> of
> 3.5 GB. We have configured SQL SERVER as a Dynamically Configure SQL
> SERVER
> memory when we installed. Now when we check memory usage of SQL SERVER
> sqlservr.exe is using a 1.7 GB of memory ? os just wondering is it normal
> ?
> Pls let us know.