I know SQL will take all the memory the box will give it. It also gives it back when Windows needs it.
What I would like to do is force SQL to return the memory periodically. More for monitoring when the SQL thinks it needs more memory.
Sp_configure is not what I am looking for. SQL will still be able to 'use' all the memory on the box (except 1 GB or OS), I just want to force the return of what it is not currently required.
Anyone know of an ONLINE way to do this that does not require rebooting, restarting or otherwise making SQL unavailable?
Thanks
Raymond Laubert
Exceptional DBA of 2009 Finalist
MCT, MCDBA, MCITP:SQL 2005 Admin,
MCSE, OCP:10g