advanced code snippet search

Posted By

tvanzele on 03/29/10


Tagged

sql DMV


Versions (?)

Memory Clerks & used vas

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. SELECT [type], memory_node_id, single_pages_kb, multi_pages_kb, virtual_memory_reserved_kb, virtual_memory_committed_kb, awe_allocated_kb
  2. FROM sys.dm_os_memory_clerks
  3. ORDER BY virtual_memory_reserved_kb DESC;

Report this snippet  

You need to login to post a comment.