SQL server Memory Usage

Question

Post reply

SQL server Memory Usage

vduggaraju

SSCommitted

Points: 1643
More actions
April 15, 2004 at 12:27 pm

#179174

Hi Team,
How can i find how much memory currently the SQL is using ?
Thanks

venkatesh

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 1

There are several easy ways:

Performance Monitor (Perfmon.exe)

- SQL Server:Memory Manager >> Total Server Memory (KB)

Using a tool like pslist.exe from SysInternals

Looking at Task Manager locally on the server.

K. Brian Kelley
@kbriankelley

vduggaraju SSCommitted Points: 1643 More actions · Answer 2

I want to rephrase the question.

I want to find exactly how much memory utilizing for SQL server as I have allocated min and max values as 4mb to 2.5 GB. When I try to capture from perform it gives me 2.5gb, I doubt it is correct.

Thanks

venkatesh

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 3

Total Server Memory is the "total amount of dynamic memory the server is currently consuming."

Target Server Memory is the "total amount of dynamic memory the server is willing to consume."

K. Brian Kelley
@kbriankelley

vduggaraju SSCommitted Points: 1643 More actions · Answer 4

Hi Brain, Thanks for you quick replay, but i have a doubt. The memory which shows under task manager for SQLSERVer.exe process is current memory usage of that process. could you please clear my doubt. Thanks in advance.

Thanks

venkatesh

phani kumar gotety Ten Centuries Points: 1213 More actions · Answer 5

Hi,

You can use following dbcc command and getting the details of memory usage MS SQL Server.

Use master

go

DBCC memorystatus

go

Thanks

Chandra

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 6

you can also look in sysperfinfo table for the information

select * from master.dbo.sysperfinfo where counter_name like '%server memory%'

When using extended memory I've found it's usually better to set min and max memory the same - on a dedicated box what else would need the memory ?

Note that when using awe task manager processes does not report the correct memory usuage e.g. my prod server which has 30Gb allocated reports 350mb in processes !

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/