Defected


Hi to alll,


I use sql server 2000 ver 8.00.2039
I would like to know if is possible to free some ram memory without restart the service .

I have about 1.7 Gb of memory used

I have just tried to use these commands


DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE
dbcc free


but seems that nothing happens

Any idea

thank you in advance



Re: SQL server 2000 memory problem

Jag Sandhu


Hi

Try the following to limit the memory usage for SQL to 1500MB.

Code Snippet

sp_configure 'max server memory', 1500

go

reconfigure with override

go

Jag







Re: SQL server 2000 memory problem

Defected

Thank you jag

it works