• sys.master_files will always show 0 for the memory optimized file because it is a FILESTREAM type.

    sys.database_files will show the used amount of data in the memory optimized file.

    You can look in the documentation for sys.master_files and sys.database_files for more information.



    Ben Miller
    Microsoft Certified Master: SQL Server, SQL MVP
    @DBAduck - http://dbaduck.com