Couple of days ago I hit a problem with restoring AdwentureWorks2016 because it contains In-Memory tables.
There was an immediate question: which tables are created In-Memory and how big they are?
Unfortunately, I couldn't answer that question in one click. So, I decided that it is a time to upgrade my "SQL on your fingertips" script and include there properties of new SQL Server objects.
I've found a DMV "sys.dm_db_xtp_memory_consumers", which provides information about Memory allocations of In-Memory tables and indexes.
And here is the script I came up with:
Here are the results from AdventureWorks2016 DB I've got:
I've updated only "Ctrl-F1" button, which returns list of tables within a database. Here is the link to the full script archive: https://drive.google.com/open?id=0B5yWoyX1eEWqZ3FJUnNHZm80bzQ