InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 00:54:55 GMT20http://www.sqlservercentral.com/Forums/Topic556555-146-1.aspxHello,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 typeThanks and regards,JMSM ;)Thu, 21 Aug 2008 07:30:08 GMTJMSM