How to Free up Memory without stopping and restating the SQL service?

  • Hi All hope some one can help

    I know that i can limit the amount of mem used by SQL 2008 but I would like to leave that as is and run a command after the SSIS and tsql scripts have run over night to free up the memory back to the system is their an SQL command to do this pleases?

  • Sorry, but there is no such command. While it's possible to remove somethings from SQL Server memory using DBCC commands, that won't release the memory to the OS.

    [font="Verdana"]Markus Bohse[/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply