August 21, 2008 at 7:30 am
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 😉
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply