memory allocation

How do I stop the sqlserver.exe to eat up all my available physical memory?
Is there a bad impact if I do so? Thanks.Let it do it's own thing Eric (loved the latest album) - it will dynamically
use up free memory as then it can expand it's cached data and query plans.
If other apps start up and need the memory, SQL will release it. You can
manually configure the amount of memory to assign to SQL but unless you have
a machine with > 4GB RAM you really should leave it dynamic.
"Eric Clapton" <no_spam@.bk.com> wrote in message
news:%233zIHFlCEHA.3064@.tk2msftngp13.phx.gbl...
> How do I stop the sqlserver.exe to eat up all my available physical
memory?
> Is there a bad impact if I do so? Thanks.
>|||Eric
Well , it is by design. SQL Server dynamically acquire and free memory as
needed.(when allowed to dynamically configured memory).That does not
indicate you have memory lack. If another program will need a memory then
SQL Server will release the memory.
Read on BOL this article 'Effects of min and max server memory
'
"Eric Clapton" <no_spam@.bk.com> wrote in message
news:#3zIHFlCEHA.3064@.tk2msftngp13.phx.gbl...
> How do I stop the sqlserver.exe to eat up all my available physical
memory?
> Is there a bad impact if I do so? Thanks.
>|||Thanks, Mary and Uri. What if I got two SQL server and want to combine it to
one SQL server? What is the formula for combined memory?
"Mary Bray" <reply@.tonewsgroup.com.NOSPAMPLEASE> wrote in message
news:uqcXlOlCEHA.1544@.TK2MSFTNGP09.phx.gbl...
> Let it do it's own thing Eric (loved the latest album) - it will
dynamically
> use up free memory as then it can expand it's cached data and query plans.
> If other apps start up and need the memory, SQL will release it. You can
> manually configure the amount of memory to assign to SQL but unless you
have
> a machine with > 4GB RAM you really should leave it dynamic.
> "Eric Clapton" <no_spam@.bk.com> wrote in message
> news:%233zIHFlCEHA.3064@.tk2msftngp13.phx.gbl...
> memory?
>