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.

http://feedproxy.google.com/~r/PaulSRandal/~3/p1GcksTq4sQ/