RSA Scripts

SQL Buffer allocations

How big are the SQL Buffer allocations and what is stealing the memory

  1. Sql Server
  2. Performance
  3. Intermediate
  4. Vaknin Sammy

Last updated:

Warning: Review and test in a non-production environment before running.

Back to results

-- How big are the SQL Buffer allocations and what is stealing the memory
SELECT SUM(multi_pages_kb + virtual_memory_committed_kb + shared_memory_committed_kb + awe_allocated_kb) AS [Buffer Pool Used]
FROM sys.dm_os_memory_clerks
WHERE type = 'MEMORYCLERK_SQLBUFFERPOOL'
GO