Showing posts with label of3. Show all posts
Showing posts with label of3. Show all posts

Monday, March 12, 2012

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.Which version of sql server 2000 do you have?. If it is standard, then it ca
n
use 2gbytes max, if it is enterprise, then you have to configure the server
in order to sql server use more than 2gb.
How to configure memory for more than 2 GB in SQL Server
http://support.microsoft.com/kb/274750/
AMB
"mvp" wrote:

> Hello Everybody,
> We have a SQL SERVER installed on a Windows 2003 SERVER which has memory o
f
> 3.5 GB. We have configured SQL SERVER as a Dynamically Configure SQL SERVE
R
> 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.|||mvp wrote:
> 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.
Are you wondering why it's using 1.7GB or why it's not using more? SQL
Server does not release memory back to the OS once it claims it, except
under certain server conditions. If you want SQL Server to not use more
than a specified amount of memory, you can set an upper memory limit.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||> 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
> ?
Sure, you have it set to take the memory it needs, and so far it has only
needed 1.7 GB. If you want to start it higher, you can do so...

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.

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.