Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT name,
- DBName = db_name(Right(name, Len(name) - 6)),
- memory_node_id,
- 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%';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement