I have a database on a SQL Server 2014 SP2, CU5 Enterprise edition.
The database has a memory optimized filegroup. There are two tables in it, both are set to
DURABILITY = SCHEMA_ONLY and have a low bucket count (e.g. 512).
I don't remember what the initial disk space of this file was, but some time ago it allocated 4 GB and has since grown to ~7 GB. When I look in the filestream files with a hex editor, it seems that they contain data from a (partitioned) datawarehouse table in the same database, but this could be due to instant file initialisation.
- Is there a way to shrink the filegroup?
- Why does the in-memory filegroup take up so much space?
- How can I verify, if (and which) other tables are using the space, since
SELECT * FROM sys.indexes AS i WHERE i.data_space_id = 8 -- = the in_memory filegroupdoes not return anything