June 13, 2002 at 5:32 am
While running DTS packages that load and unload large data files, SQL takes large amounts of RAM.
I would like to allocate a good portion of RAM to SQL, but it does not release the RAM following the completion of the DTS.
Is there a way to make SQL automatically release the memory short of stopping aand restarting the SQL service?
June 13, 2002 at 12:30 pm
Not that I know of. My guess is that SQL maintains a "needed" amount and then keeps anything allocated above that until another process asks for it.
Can you try starting up some memory intensive task afterwards and see if any is "released"?
Steve Jones
June 13, 2002 at 6:14 pm
Steve is right, SQL is planning for the need again but if something else needs the memory the OS will reallocate and inform SQL to play nice.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply