September 21, 2012 at 10:49 am
Why is it that sqlservr.exe process is using almost 5GB when viewed in task manager but sql server is set to use max server memory of 4096MB?
September 21, 2012 at 11:04 am
Firstly, don't use Task Manager to check SQL's memory, it can be very wrong.
The max server memory affects the buffer pool size. There's additional memory used outside of the buffer pool
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 21, 2012 at 11:48 am
From SQL you can use this to find the total amount of memory SQL Server is using:
SELECT cntr_value / 1024.0 AS TotalServerMemoryMB
FROM sys.dm_os_performance_counters
WHERE counter_name = 'Total Server Memory (KB)';
Look for the counter named MSSQL$InstanceName:MemoryManager:Total Server Memory (KB) if using Performance Monitor in Windows.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 21, 2012 at 2:28 pm
The memory consumption report has this for the buffer pool (allocated memory, virtual reserved, virtual committed).
MEMORYCLERK_SQLBUFFERPOOL440 (allocated)6,184,960 (reserved)4,001,640(committed)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply