Skip to content
«
»
 

Finding the total virtual, shared and AWE memory used

Posted by 
on  May 31 2009

This query shows:

  1. Amount of memory allocated to the buffer pool
  2. Amount of memory consumed by BPool
  3. Amount of memory used by AWE
SELECT
    SUM(single_pages_kb
        + virtual_memory_committed_kb
        + shared_memory_committed_kb
        + awe_allocated_kb) as [Used by BPool with AWE, Kb]
FROM
    sys.dm_os_memory_clerks
WHERE
    type = 'MEMORYCLERK_SQLBUFFERPOOL'


Popular search terms:
Filed under DMV Queries
Comment (RSS)  |  Permalink

post a comment OR Post Your Question on our ASK! Community!

«
»