Sql Server not Releasing memory ???

[mooki]

I have several big inserts selected from openquery and linked server.

Insert into X
select * from openquery(LINKED,'.....

IT Seems that it grabs about 140MB of the memory and did not deallocate them !!!!!

in the memory configuration i put min-0 and max-256...

IS THAT ITS NORMAL BEHAVIOUR ???? :-0

 

[pmsbony]

I realise this post was a while ago, but if anyone got any response to this I would be grateful, our SQL box is taking loads of RAM (anything up to half a gb) and will not release it unless you stop and restart the SQL service, has anyone had this issue before?

 

[AshleyRickards]

This is completely normal. SQL will hold the memory and if it detects another application which requires the memory, it will release it. Ashley L Rickards
SQL DBA