memory usage and "lock pages in memory"

#1

I've got an SQL Server 2005 Sp2 where I have configured the "Loack pages in
memory" option (http://msdn.microsoft.com/en-us/library/ms190730.aspx).
When I now look at memory usage in task manager the sqlsrv.exe process
consumes about 200000k of memory. But when I look in performance monitor,
with the "Target Server Memory" counter and "Total Server Memory" Counter,
I've got 21505024KB allocated, and this is the same as I've configured as max
memory in the SQL Server.
Why this discrepency?

#2

Task manager does not see all the memory that SQL Server can and is not the
proper tool for monitoring it. Always use perfmon.

Andrew J. Kelly SQL MVP
Solid Quality Mentors

"MRWildiac" <MRWildiac (AT) discussions (DOT) microsoft.com> wrote

Quote:

I've got an SQL Server 2005 Sp2 where I have configured the "Loack pages
in
memory" option (http://msdn.microsoft.com/en-us/library/ms190730.aspx).
When I now look at memory usage in task manager the sqlsrv.exe process
consumes about 200000k of memory. But when I look in performance monitor,
with the "Target Server Memory" counter and "Total Server Memory" Counter,
I've got 21505024KB allocated, and this is the same as I've configured as
max
memory in the SQL Server.
Why this discrepency?

--

#3

This blog entry will help you understand
http://blogs.msdn.com/psssql/archive...rking-set.aspx

Chris

"MRWildiac" <MRWildiac (AT) discussions (DOT) microsoft.com> wrote

Quote:

I've got an SQL Server 2005 Sp2 where I have configured the "Loack pages
in
memory" option (http://msdn.microsoft.com/en-us/library/ms190730.aspx).
When I now look at memory usage in task manager the sqlsrv.exe process
consumes about 200000k of memory. But when I look in performance monitor,
with the "Target Server Memory" counter and "Total Server Memory" Counter,
I've got 21505024KB allocated, and this is the same as I've configured as
max
memory in the SQL Server.
Why this discrepency?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

memory usage and "lock pages in memory"

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup

memory usage and "lock pages in memory" - 09-15-2009 , 04:32 AM

Re: memory usage and "lock pages in memory" - 09-15-2009 , 09:08 AM

Re: memory usage and "lock pages in memory" - 09-15-2009 , 10:19 AM