Sql server service using too much memory

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

R.Fabbri - 30 May 2007 10:31 GMT

Hi ,

i have sql server 2000 Sp3a on a compaq proliant 370 with 3Gb ram.
i found then sqlserver.exe service process seems to never release memory.
When i start the service the memory occupation was about 120 Mb.
This value increases with time passing up to 1,5 gb .I think this is not
normal
and may be caused by securuty problem . Antivirus (symantec 10.1) is
installed
doesn't find viruses.
Can you help to find which is the origin of this problem ?
Any help would be appreciated.
Thank you

Signature

Roberto Fabbri

Reply to this Message

vt - 30 May 2007 10:55 GMT

Hi

What's your sql server 's memory configuration ?
if its set to 'Dynamically configure' then there is nothing abnormal with
that, use the fixed memory configuration option if you want to limit the
memory usage

Regards
VT
Knowledge is power, share it....
http://oneplace4sql.blogspot.com/

> Hi ,
>
[quoted text clipped - 9 lines]
> Any help would be appreciated.
> Thank you

Reply to this Message

R.Fabbri - 30 May 2007 11:09 GMT

it is set to dynamic...

Thanks

roberto

Signature

Roberto Fabbri

> Hi
>
[quoted text clipped - 21 lines]
> > Any help would be appreciated.
> > Thank you

Reply to this Message

Andrew J. Kelly - 30 May 2007 14:54 GMT

That is exactly the intended behavior of SQL Server. Once it gets memory it
does not release it unless the OS specifically asks for it. Then it may take
it back again after the OS is done with it if SQL needs more.

http://sqljunkies.com/Tutorial/0D4FF40A-695C-4327-A41B-F9F2FE2D58F6.scuk
Memory
http://www.sql-server-performance.com/awe_memory.asp Using AWE Memory
http://www.support.microsoft.com/?id=321363 SQL Server 7 & 2000 memory
usage
http://www.support.microsoft.com/?id=274750 Memory config
http://www.support.microsoft.com/?id=283037 Large Memory Support Is
Available in Windows 2000 (AWE)
http://www.support.microsoft.com/?id=811891 Can not use more than 2GB of
memory

Signature

Andrew J. Kelly SQL MVP

> Hi ,
>
[quoted text clipped - 9 lines]
> Any help would be appreciated.
> Thank you

Reply to this Message