December 30, 2002 at 6:29 pm
How do I remove a user database from memory after it has been physically deleted?
When I query a large table in the database for the first time, SS2K loads the data into memory (memory usage jumps from 120k to 330k). Next, I clear all connections to the database and delete the database. However, memory usage does not decrease back to 120k (it remains at 330k). Right now the only way to remove the data from memory is if I restart the machine.
Is there a better way? How do I give the machine amensia (ie. remove the database from memory, ha ha)?
December 30, 2002 at 8:54 pm
DBCC DROPCLEANBUFFERS and DBCC FREEPROCCACHE should free some. In general don't worry about the memory, SQL uses everything you give it and that is a good thing. As other requests need memory, it gets reallocated - it's not orphaned.
Andy
December 31, 2002 at 4:44 am
Besides memory allocation is costly compared to already being owned. If something else needs and the memory is not currently in use the OS will make this determination.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply