Memory Usage Exceeded Maximum Memory Configuration

Hi,
I'm running SQL Server 2000 on an NT Workstation with 1GB
of memory. I've configured the maximum memory of the SQL
Server to be 512MB, but when I check Task Manager it shows
the Memory Usage of sqlservr.exe to be more than 512MB.
(Currently at 560MB). Is it normal that sqlservr.exe will
use more than the maximum allowed?
Thanks in advance,
Alice
SQL Server Version I'm running:
Microsoft SQL Server 2000 - 8.00.534 (Intel X86)
Nov 19 2001 13:23:50
Copyright (c) 1988-2000 Microsoft Corporation
Personal Edition on Windows NT 4.0 (Build 1381:
Service Pack 6)Maximum memory is for Physical Memory.
Task manager shows all, physical and virtual memory.
"Alice" wrote:
> Hi,
> I'm running SQL Server 2000 on an NT Workstation with 1GB
> of memory. I've configured the maximum memory of the SQL
> Server to be 512MB, but when I check Task Manager it shows
> the Memory Usage of sqlservr.exe to be more than 512MB.
> (Currently at 560MB). Is it normal that sqlservr.exe will
> use more than the maximum allowed?
> Thanks in advance,
> Alice
> SQL Server Version I'm running:
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86)
> Nov 19 2001 13:23:50
> Copyright (c) 1988-2000 Microsoft Corporation
> Personal Edition on Windows NT 4.0 (Build 1381:
> Service Pack 6)
>
>
>
>|||The Max setting is for the memory pool only. There is an area called
MemtoLeave (by default up to 256MB) that is not part of that setting so it
is possible for SQL Server to use more than the Max under certain
conditions.
--
Andrew J. Kelly SQL MVP
"Alice" <achan@.icescape.com> wrote in message
news:278f601c46392$73dd3b30$a401280a@.phx.gbl...
> Hi,
> I'm running SQL Server 2000 on an NT Workstation with 1GB
> of memory. I've configured the maximum memory of the SQL
> Server to be 512MB, but when I check Task Manager it shows
> the Memory Usage of sqlservr.exe to be more than 512MB.
> (Currently at 560MB). Is it normal that sqlservr.exe will
> use more than the maximum allowed?
> Thanks in advance,
> Alice
> SQL Server Version I'm running:
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86)
> Nov 19 2001 13:23:50
> Copyright (c) 1988-2000 Microsoft Corporation
> Personal Edition on Windows NT 4.0 (Build 1381:
> Service Pack 6)
>
>
>
>