| Hilary Cotter 2006-10-24, 6:38 pm |
| Why do you feel the need to release memory? By default sql server will
allocate and deallocate memory on the fly on an as needed basis. To release
the procedure cache issue a DBCC FREEPROCCACHE, to release the buffer pool
issue a DBCC DROPCLEANBUFFERS
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Erencan SAŠIROŠLU" <erencans@hotmail.com> wrote in message
news:uQkZWWP9GHA.1492@TK2MSFTNGP02.phx.gbl...
> Hi All,
> I have a question. SQL Server 's memory increase always. How can i release
> SQL Server's memory?
> When i do stop-start so SQL Server release memory. But i have to release
> memory a different way.
>
> Thaks alot.
>
>
|