Force memory release

Hi all,
in SQL Server 2005 is it possible to force the SQL Server runtime to release
memory when it's not working?
Thanks a lot.
--
LuigiLuigi
If some application/os needs e memory , SQL Server will release it , if you
set up MIN server memory BOL says
/*
The database engine will not free any of the acquired memory until it
reaches the amount specified in min server memory. Once min server memory is
reached, the database engine then uses the standard algorithm (keeping the
operating system's free memory within 4 MB to 10 MB) to acquire and free
memory as needed
*/
"Luigi" <ciupazNoSpamGrazie@.inwind.it> wrote in message
news:979ED183-7761-477A-89B8-E8FB11EF7DA1@.microsoft.com...
> Hi all,
> in SQL Server 2005 is it possible to force the SQL Server runtime to
> release
> memory when it's not working?
> Thanks a lot.
> --
> Luigi
>|||"Luigi" <ciupazNoSpamGrazie@.inwind.it> wrote in message
news:979ED183-7761-477A-89B8-E8FB11EF7DA1@.microsoft.com...
> Hi all,
> in SQL Server 2005 is it possible to force the SQL Server runtime to
> release
> memory when it's not working?
> Thanks a lot.
> --
> Luigi
>
Not exactly. SQL Server will dynamically allocate and deallocate memory as
it needs it. If you find other applications are being starved for memory,
there are a couple of things you can do.
1. In my opinion, a production SQL Server should live on it's own box and
that box should be doing nothing other than SQL Server.
2. If you can't do this, then take a look at the max server memory option.
This will limit the amount of memory SQL Server can use for it's own use.
Other potential memory saving options might be to clear/drop the buffer
cache and procedure cache. I don't know if this will force SQL to give up
the memory. The downside of course is that any sprocs and other saved
execution plans will be forced to recompile. In addition, any indexes and
data pages that had been put into buffer for speedy access will now need to
be reloaded, which means more i/o which of course means slower response
times.
Rick Sawtell|||Ok, very exaustive. Thanks a lot Uri and Rick.
Luigi