Advertisement
SQLSoldier

Check In-Memory Memory Usage

Dec 27th, 2016
232
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.23 KB | None | 0 0
  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%';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement