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.

Megan
SELECT * FROM sys.dm_os_performance_counters

WHERE counter_name = 'Total Server Memory (KB)'

OR counter_name = 'Target Server Memory (KB)';

SELECT * FROM sys.dm_os_performance_counters

WHERE counter_name = 'Page life expectancy'

AND object_name = 'SQLServer:Buffer Manager';



SQL Server allocates memory dynamically unless you set MAX/MIN memory
value. When OS or other application needs the memory SQL Server will release
it

Make sure that you granted permission to accounnt SQL Server runs under for
Lock Pages in Memory (local policy)









"Megan Kielman" <megan.kielman@gmail.com> wrote in message
news:OIp23Y1FJHA.828@TK2MSFTNGP03.phx.gbl...
>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 you explain what the SQL query results mean?

When you say that SQL Server allocates memory dynamically, does that
mean that the counter 'Total Server Memory' is the amount of physical
memory SQL Server is using? If so, why isn't this memory reported by the
sqlserv.exe process?





Uri Dimant wrote:
> Megan
> SELECT * FROM sys.dm_os_performance_counters
>
> WHERE counter_name = 'Total Server Memory (KB)'
>
> OR counter_name = 'Target Server Memory (KB)';
>
> SELECT * FROM sys.dm_os_performance_counters
>
> WHERE counter_name = 'Page life expectancy'
>
> AND object_name = 'SQLServer:Buffer Manager';
>
>
>
> SQL Server allocates memory dynamically unless you set MAX/MIN memory
> value. When OS or other application needs the memory SQL Server will release
> it
>
> Make sure that you granted permission to accounnt SQL Server runs under for
> Lock Pages in Memory (local policy)
>
>
>
>
>
>
>
>
>
> "Megan Kielman" <megan.kielman@gmail.com> wrote in message
> news:OIp23Y1FJHA.828@TK2MSFTNGP03.phx.gbl...
>> 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.
>
>

Megan
ms-://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/62021d0b-1b8d-4276-b373-a01184006d42.htm




"Megan Kielman" <megan.kielman@gmail.com> wrote in message
news:eqnpQKBGJHA.6052@TK2MSFTNGP04.phx.gbl...
> Can you explain what the SQL query results mean?
>
> When you say that SQL Server allocates memory dynamically, does that mean
> that the counter 'Total Server Memory' is the amount of physical memory
> SQL Server is using? If so, why isn't this memory reported by the
> sqlserv.exe process?
>
>
>
>
>
> Uri Dimant wrote:
>> Megan
>> SELECT * FROM sys.dm_os_performance_counters
>>
>> WHERE counter_name = 'Total Server Memory (KB)'
>>
>> OR counter_name = 'Target Server Memory (KB)';
>>
>> SELECT * FROM sys.dm_os_performance_counters
>>
>> WHERE counter_name = 'Page life expectancy'
>>
>> AND object_name = 'SQLServer:Buffer Manager';
>>
>>
>>
>> SQL Server allocates memory dynamically unless you set MAX/MIN memory
>> value. When OS or other application needs the memory SQL Server will
>> release it
>>
>> Make sure that you granted permission to accounnt SQL Server runs under
>> for Lock Pages in Memory (local policy)
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> "Megan Kielman" <megan.kielman@gmail.com> wrote in message
>> news:OIp23Y1FJHA.828@TK2MSFTNGP03.phx.gbl...
>>> 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.
>>

I'm sorry to sound ignorant but how to I access that?


Uri Dimant wrote:
> Megan
> ms-://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/62021d0b-1b8d-4276-b373-a01184006d42.htm
>
>
>
>
> "Megan Kielman" <megan.kielman@gmail.com> wrote in message
> news:eqnpQKBGJHA.6052@TK2MSFTNGP04.phx.gbl...
>> Can you explain what the SQL query results mean?
>>
>> When you say that SQL Server allocates memory dynamically, does that mean
>> that the counter 'Total Server Memory' is the amount of physical memory
>> SQL Server is using? If so, why isn't this memory reported by the
>> sqlserv.exe process?
>>
>>
>>
>>
>>
>> Uri Dimant wrote:
>>> Megan
>>> SELECT * FROM sys.dm_os_performance_counters
>>>
>>> WHERE counter_name = 'Total Server Memory (KB)'
>>>
>>> OR counter_name = 'Target Server Memory (KB)';
>>>
>>> SELECT * FROM sys.dm_os_performance_counters
>>>
>>> WHERE counter_name = 'Page life expectancy'
>>>
>>> AND object_name = 'SQLServer:Buffer Manager';
>>>
>>>
>>>
>>> SQL Server allocates memory dynamically unless you set MAX/MIN memory
>>> value. When OS or other application needs the memory SQL Server will
>>> release it
>>>
>>> Make sure that you granted permission to accounnt SQL Server runs under
>>> for Lock Pages in Memory (local policy)
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> "Megan Kielman" <megan.kielman@gmail.com> wrote in message
>>> news:OIp23Y1FJHA.828@TK2MSFTNGP03.phx.gbl...
>>>> 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.
>

Open up your Books Online (SQL Server's documentation) and enter that in the
URL box.

--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
www.SQLTuners.com


"Uri Dimant" <urid@iscar.co.il> wrote in message
news:eN84c$HGJHA.1020@TK2MSFTNGP06.phx.gbl...
> Megan
> ms-://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/62021d0b-1b8d-4276-b373-a01184006d42.htm
>
>
>
>
> "Megan Kielman" <megan.kielman@gmail.com> wrote in message
> news:eqnpQKBGJHA.6052@TK2MSFTNGP04.phx.gbl...
>> Can you explain what the SQL query results mean?
>>
>> When you say that SQL Server allocates memory dynamically, does that mean
>> that the counter 'Total Server Memory' is the amount of physical memory
>> SQL Server is using? If so, why isn't this memory reported by the
>> sqlserv.exe process?
>>
>>
>>
>>
>>
>> Uri Dimant wrote:
>>> Megan
>>> SELECT * FROM sys.dm_os_performance_counters
>>>
>>> WHERE counter_name = 'Total Server Memory (KB)'
>>>
>>> OR counter_name = 'Target Server Memory (KB)';
>>>
>>> SELECT * FROM sys.dm_os_performance_counters
>>>
>>> WHERE counter_name = 'Page life expectancy'
>>>
>>> AND object_name = 'SQLServer:Buffer Manager';
>>>
>>>
>>>
>>> SQL Server allocates memory dynamically unless you set MAX/MIN memory
>>> value. When OS or other application needs the memory SQL Server will
>>> release it
>>>
>>> Make sure that you granted permission to accounnt SQL Server runs under
>>> for Lock Pages in Memory (local policy)
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> "Megan Kielman" <megan.kielman@gmail.com> wrote in message
>>> news:OIp23Y1FJHA.828@TK2MSFTNGP03.phx.gbl...
>>>> 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.
>>>
>

Open up your Books Online (SQL Server's documentation) and enter that in the
URL box.

--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
www.SQLTuners.com


"Megan Kielman" <megan.kielman@gmail.com> wrote in message
news:OerJPaQGJHA.2252@TK2MSFTNGP02.phx.gbl...
> I'm sorry to sound ignorant but how to I access that?
>
>
> Uri Dimant wrote:
>> Megan
>> ms-://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/62021d0b-1b8d-4276-b373-a01184006d42.htm
>>
>>
>>
>>
>> "Megan Kielman" <megan.kielman@gmail.com> wrote in message
>> news:eqnpQKBGJHA.6052@TK2MSFTNGP04.phx.gbl...
>>> Can you explain what the SQL query results mean?
>>>
>>> When you say that SQL Server allocates memory dynamically, does that
>>> mean that the counter 'Total Server Memory' is the amount of physical
>>> memory SQL Server is using? If so, why isn't this memory reported by the
>>> sqlserv.exe process?
>>>
>>>
>>>
>>>
>>>
>>> Uri Dimant wrote:
>>>> Megan
>>>> SELECT * FROM sys.dm_os_performance_counters
>>>>
>>>> WHERE counter_name = 'Total Server Memory (KB)'
>>>>
>>>> OR counter_name = 'Target Server Memory (KB)';
>>>>
>>>> SELECT * FROM sys.dm_os_performance_counters
>>>>
>>>> WHERE counter_name = 'Page life expectancy'
>>>>
>>>> AND object_name = 'SQLServer:Buffer Manager';
>>>>
>>>>
>>>>
>>>> SQL Server allocates memory dynamically unless you set MAX/MIN memory
>>>> value. When OS or other application needs the memory SQL Server will
>>>> release it
>>>>
>>>> Make sure that you granted permission to accounnt SQL Server runs
>>>> under for Lock Pages in Memory (local policy)
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> "Megan Kielman" <megan.kielman@gmail.com> wrote in message
>>>> news:OIp23Y1FJHA.828@TK2MSFTNGP03.phx.gbl...
>>>>> 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.
>>

Thanks for the assistance. I read the article but it didn't answer one
of my questions.

Why isn't the amount of memory used by SQL (as reported by Total Server
Memory) accounted for by the sqlserv.exe process? In other words, why
does the sqlserv.exe process only show a few hundred MB of a Working Set
when Total Server Memory shows over 30GB?

I am running Windows 2003x64 w/ SQL 2005



Kalen Delaney wrote:
> Open up your Books Online (SQL Server's documentation) and enter that in the
> URL box.
>