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.