Why are the last update dates of SQL Server data files and log files inaccurate?

Someone asked why SQL server data has changed, but why is the best modification date of database files and log files not changed. In fact, this is a normal behavior.

 

The modification date of the SQL Server File is when the SQL server closes the file (shutdown or the database is detach, offline) or the SQL server data file or log file increases (automatic or manual growth, these are all tested by myself ). In other cases, SQL Server directly updates data without bypassing the file system, so it does not update modify date.

 

From the performance perspective, if SQL Server updates the file modify date every time, the overhead is very large for a large OLTP transaction database in seconds.

 

In addition, database users are concerned with data changes, which are queried from the database application software, rather than through the Windows file system. In addition, after the database is started, only SQL server can exclusively update data files and log files, so there is no other software update, so the last file update time is not very important.

 

Welcome to the discussion.