G2A Many GEOs
SHARE
TWEET

Check In-Memory Memory Usage

SQLSoldier Dec 27th, 2016 99 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
Ledger Nano X - The secure hardware wallet
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top