Do values in `sys.dm_os_wait_stats` reset to 0 or stop accumulating when they hit the max value?

by sp_BlitzErik   Last Updated September 20, 2017 15:06 PM

When looking at sys.dm_os_wait_stats, the following columns are defined as BIGINT

  • waiting_tasks_count
  • wait_time_ms
  • max_wait_time_ms

If any of those values go above 9,223,372,036,854,775,807, do the counters reset to 0, or simply stop counting?

It's unclear from the table definition what goes on behind the scenes:

sp_helptext 'sys.dm_os_wait_stats'


CREATE VIEW sys.dm_os_wait_stats AS  

So that's a bit of a black box.

Tags : sql-server dmv

Related Questions

creating index on big table(s)

Updated September 03, 2018 18:06 PM

Linked Server Error on SQL Agent Job

Updated March 16, 2016 08:02 AM