November 18, 2011 at 3:34 pm
Greetings,
I am having a bit of an issue with setting the max memory on a server. I ran the following,
EXEC sp_configure 'Show Advanced Options',1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'max server memory', 27264;
RECONFIGURE
GO
...and now the results of EXEC sp_configure 'max server memory (MB)' show the config and run value I'm looking for.
name minimummaximum config_valuerun_value
max server memory (MB)1621474836472726427264
The problem is when I remote on to the server and check out the resource monitor I see on the Memory tab that SQL is still taking ~30 GB of memory. When I ran this on a different server the results were immediate in the resource monitor.
Why hasn't this changed? Do I need a restart (which I'm unable to do right now)?
Thanks,
Tim
November 18, 2011 at 4:29 pm
This may not be an error, as Max Server memory affects the buffer pool only, not objects stored outside of the buffer pool. Worker Memory, Linked Servers, Multi-Page allocations, large query plans, SQLCLR, OLE Automation calls, network packet sizes > 8K, Service Broker connections, and some other items all allocate memory outside of the Buffer Pool.
You may run the following query to get an idea of what is taking up memory:
select
SUM(pages_allocated_count)*8 as MemKB,
type
from
sys.dm_os_memory_objects
group by
type
order by
MemKB desc
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply