Finding the total virtual, shared and AWE memory used

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

[cc lang=”sql”]
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’
[/cc]

Featured Articles

 Site Author

  • Thanks for visiting!