Check In-Memory Memory Usage
SQLSoldier Dec 27th, 2016 85 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- SELECT name,
- DBName = db_name(Right(name, Len(name) - 6)),
- pages_kb/1024.0 AS pages_MB,
- pages_kb/1024/1024.0 AS pages_GB
- FROM sys.dm_os_memory_clerks
- WHERE type = N'MEMORYCLERK_XTP'
- And name Like N'DB_ID%';
RAW Paste Data