max mem field not working

Hi,
i explained to SQL 2005 express that the max mem it could use was 500mb (via
the Max server memory field in Mem option on properties).
yet when i examine task manager its using 800mb.
Any idea why ?
Need to stop restart for changes to take effect maybe ?
Thanks
Scott> i explained to SQL 2005 express that the max mem it could use was 500mb
> (via the Max server memory field in Mem option on properties).
> yet when i examine task manager its using 800mb.
> Any idea why ?
> Need to stop restart for changes to take effect maybe ?
Yes, it is not going to choke a SQL Server process that is already running
in more memory space.
You can see details in:
select * from sys.configurations where [name] = 'max server memory (MB)';
I'll bet "value_in_use" is > "maximum"... that will correct itself once you
stop and start SQL Server.|||Additionally to what Aaron said, take in consideration that SQL Server
2005 Express will take a bit more memory than that anyway, because the
memory specified is exclusively for the memory pool. Except something
between 30mb to 100mb extra to that 800mb.
Cesar Vega
http://www.databasecorner.com
On Mar 21, 9:58 am, "Scott" <s...@.yahoo.com> wrote:
> Hi,
> i explained to SQL 2005 express that the max mem it could use was 500mb (via
> the Max server memory field in Mem option on properties).
> yet when i examine task manager its using 800mb.
> Any idea why ?
> Need to stop restart for changes to take effect maybe ?
> Thanks
> Scott