Memory

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.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 SAIROLU" <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.
>|||And some reading on the subject:
INF: SQL Server Memory Usage
http://support.microsoft.com/defaul...b;en-us;q321363
http://www.mssqlserver.com/faq/trou...-memoryleak.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OxqAkmQ9GHA.3740@.TK2MSFTNGP05.phx.gbl...
> Why do you feel the need to release memory? By default sql server will all
ocate and deallocate
> memory on the fly on an as needed basis. To release the procedure cache is
sue 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 p
ositions, 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 SAIROLU" <erencans@.hotmail.com> wrote in message
> news:uQkZWWP9GHA.1492@.TK2MSFTNGP02.phx.gbl...
>|||Hi,
Make the SQL Server memory static; this will make sure the other application
gets enough memory.
But do not release the memory using DBCC FREEPROCCACHE or DBCC
DROPCLEANBUFFERS, this will cause
Data cache and procedure cache to get flushed and cause performance bottle
neck
Thanks
Hari
"Erencan SAIROLU" <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.
>