Page memory error

[Daniel Resende]

Hi everyone!

My Server W2K is give me an error constantly.

I have looked in the task manager that the SQL Server 2000
is getting a lot of memory and isn't liberating nothing at
all.

Some hours later my Server couldn't do any task because it
couldn't allocate more memory to execute them.

What can I do to avoid this? Have anyone an idea for this?

My Server is updated with SP3 yet and have 1.4Ghz with 512
RAM.

Thanks,

Daniel Resende
Support Analist

 

[Aurelien [MS]]

Hi everyone!

My Server W2K is give me an error constantly.

I have looked in the task manager that the SQL Server 2000
is getting a lot of memory and isn't liberating nothing at
all.

Some hours later my Server couldn't do any task because it
couldn't allocate more memory to execute them.

What can I do to avoid this? Have anyone an idea for this?

My Server is updated with SP3 yet and have 1.4Ghz with 512
RAM.

Thanks,

Daniel Resende
Support Analist

_________

Hi,

It seems that you are face a SQL memory leak.
I am not a specialist in SQL, but when I have a look in Microsoft Knowledge
base I see a lot or article about SQL memory leak.

If I were you I would ask the question in the SQL newsgroup, they are more
experimented in SQL issues and will be more able to help you.
microsoft.public.sqlserver.server

Aurelien Goillot
Microsoft France