Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to check what is using memory.. Expand / Collapse
Author
Message
Posted Thursday, August 21, 2008 7:30 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 4:53 AM
Points: 186, Visits: 818
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 »

Add to briefcase

Permissions Expand / Collapse