SHARE
TWEET

Check In-Memory Memory Usage

SQLSoldier Dec 27th, 2016 80 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT name,
  2.     DBName = db_name(Right(name, Len(name) - 6)),
  3.     memory_node_id,
  4.     pages_kb/1024.0 AS pages_MB,
  5.     pages_kb/1024/1024.0 AS pages_GB
  6. FROM sys.dm_os_memory_clerks
  7. WHERE type = N'MEMORYCLERK_XTP'
  8. And name Like N'DB_ID%';
RAW Paste Data
Pastebin PRO Summer Special!
Get 40% OFF on Pastebin PRO accounts!
Top