MS SQL Server - max memory

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

max memory

Aramid

2006-01-30, 1:23 pm

Hi All,

I noticed that SQL 2000 seems to be eating up a bit more memory
(about 100Mb more) than the maximum memory that I have set. Is this a
normal behavior?

Thanks.

Aramid

Andrew J. Kelly

2006-01-30, 1:23 pm

The MAX Memory setting is for the memory pool only and does not take into
account the MemToLeave area. The MemToLeave can take up to 384MB's in
addition to the Max Memory if there is enough to go around.

--
Andrew J. Kelly SQL MVP

"Aramid" <aramid@hotmail.com> wrote in message
news:44kst11d8pu4g6n
hmch70q9la3ngu02jav@
4ax.com...
> Hi All,
>
> I noticed that SQL 2000 seems to be eating up a bit more memory
> (about 100Mb more) than the maximum memory that I have set. Is this a
> normal behavior?
>
> Thanks.
>
> Aramid

Sponsored Links