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.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/
"Erencan SAIROLU" <erencans@.hotmail.com> wrote in message
news:uXedWpM%23GHA.1224@.TK2MSFTNGP05.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.
>|||Thank you Tubor. I understand now my problem.
We use SBS and SQL Server 2000. SBS don't allow SQL Server to use over 2 GB
memory.
But SQL Server release memory when OS 's resources is low. But PC has 5 GB
RAM.
For this reason one couple of days after SQL Server performance very poor.
(So i think it use virtual memory probably.)
But i wonder that why microsoft doesn't fix this problem?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u4hun9M%23GHA.1220@.TK2MSFTNGP05.phx.gbl...
> 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/
>
> "Erencan SAIROLU" <erencans@.hotmail.com> wrote in message
> news:uXedWpM%23GHA.1224@.TK2MSFTNGP05.phx.gbl...
>