A prior student emailed me yesterday about some strange behavior of the sample_ms column in sys.dm_io_virtual_file_stats. Its supposed to be the number of milliseconds since the SQL Server instance has been started. He has a SQL Server 2016 instance thats been running since August 2019, and it shows the following: ms_ticks from sys.dm_os_sys_info: 51915112684 (which works out to [&]

The post Small bug with sample_ms in sys.dm_io_virtual_file_stats appeared first on Paul S. Randal.

https://www.sqlskills.com/blogs/paul/small-bug-with-sample_ms-in-sys-dm_io_virtual_file_stats/