Memory Usage

25 Aug 2005 1:46 PM

mvp

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.

25 Aug 2005 2:00 PM

Alejandro Mesa

Which version of sql server 2000 do you have?. If it is standard, then it can
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

Show quote

"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.

25 Aug 2005 2:01 PM

David Gugick

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

25 Aug 2005 3:08 PM

Aaron Bertrand [SQL Server MVP]

> 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...