How to check what is using memory..

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » How to check what is using memory..

How to check what is using memory..

Rate Topic

Display Mode

Topic Options

Author

Message

JMSM

Posted Thursday, August 21, 2008 7:30 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 6:20 AM
Points: 185, Visits: 759

Hello,

Can anybody tell me what should i do to check what is exacly using memory in my SQL Server Instance.
Another question, how can i check what part of memory is really used by SQL Server of the amount of memory that i defined in Server Memory Options.

I try to use dbcc memorystautus but i dont understand what kind of results should i expect.
Then i run this query but i've got the same problem.

Can anybody explain this to me or send me links where i can check this points?

select
type,
sum(virtual_memory_reserved_kb) as [VM Reserved],
sum(virtual_memory_committed_kb) as [VM Committed],
sum(awe_allocated_kb) as [AWE Allocated],
sum(shared_memory_reserved_kb) as [SM Reserved],
sum(shared_memory_committed_kb) as [SM Committed],
sum(multi_pages_kb) as [MultiPage Allocator],
sum(single_pages_kb) as [SinlgePage Allocator]
from
sys.dm_os_memory_clerks
group by type

Thanks and regards,
JMSM ;)

Post #556555

« Prev Topic | Next Topic »

Permissions