I am running Windows 2003 SP2 x64 with SQL Server 2005 X64. Does the
counter SQLServer:Memory Manager/Total Server Memory (KB) show the
amount of physical memory is use by SQL? Why isn't this value reported
by the sqlservr.exe working set?

I am concerned about SQL Server usage b/c it continues to grow and the
system which has 34GB of memory generally runs with 300MB available.

On my boxes, I have noticed that Process: working set for sqlservr is
sometimes not accurate in terms of the memory recently touched by the
process. For instance, on this x64 machine running everything x64, the
working seting only about 218MB with the working set peak value slightly over
420MB, when SQLServer:Memory Manager\Total Memory reports 29GB. It's possible
that not all that 29GB of the buffer pool memory is recently touched. But I'm
pretty sure that recent activities on that instance should have used far more
than just 200MB.

Linchi

"Megan Kielman" wrote:

> I am running Windows 2003 SP2 x64 with SQL Server 2005 X64. Does the
> counter SQLServer:Memory Manager/Total Server Memory (KB) show the
> amount of physical memory is use by SQL? Why isn't this value reported
> by the sqlservr.exe working set?
>
> I am concerned about SQL Server usage b/c it continues to grow and the
> system which has 34GB of memory generally runs with 300MB available.
>

Can anyone on this forum explain what we are seeing?


Linchi Shea wrote:
> On my boxes, I have noticed that Process: working set for sqlservr is
> sometimes not accurate in terms of the memory recently touched by the
> process. For instance, on this x64 machine running everything x64, the
> working seting only about 218MB with the working set peak value slightly over
> 420MB, when SQLServer:Memory Manager\Total Memory reports 29GB. It's possible
> that not all that 29GB of the buffer pool memory is recently touched. But I'm
> pretty sure that recent activities on that instance should have used far more
> than just 200MB.
>
> Linchi
>
> "Megan Kielman" wrote:
>
>> I am running Windows 2003 SP2 x64 with SQL Server 2005 X64. Does the
>> counter SQLServer:Memory Manager/Total Server Memory (KB) show the
>> amount of physical memory is use by SQL? Why isn't this value reported
>> by the sqlservr.exe working set?
>>
>> I am concerned about SQL Server usage b/c it continues to grow and the
>> system which has 34GB of memory generally runs with 300MB available.
>>