This provides information on the memory usage by the in-memory tables in a database. After a little playing I tweaked the query like this:
select OBJECT_NAME(object_id) TableName, * from sys.dm_db_xtp_table_memory_stats where object_id > 0
Now I can get a quick list of my in-memory tables and the memory used as shown below. The database used is the model airplane database from Ami Levin and my new book on in-memory features coming this summer from Apress. You can also check out the new In-Memory Virtual User group we are running for SQL Pass.