Inconsistent data in database_files and master_files ?

• AppSup_dba

  SSCrazy

  Points: 2215

  More actions

  April 21, 2015 at 2:44 am

  #398357

  Hello Experts,

  USE <database>

  select * from sys.database_files

  and

  select * from sys.master_files where database_id= <db id>

  give me different size of memory optimized file in <database>

  Any ideas what might have caused this?

  Microsoft SQL Server 2014 - 12.0.2456.0 (X64)

  Cheers

• Ben Miller

  SSCrazy

  Points: 2995

  More actions

  April 21, 2015 at 7:49 am

  #1792406

  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