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'

Returns:

CREATE VIEW sys.dm_os_wait_stats AS  
 SELECT *  
 FROM OpenRowset(TABLE SYSWAITSTATS)  

So that's a bit of a black box.

Tags : sql-server dmv


Related Questions


Linked Server Error on SQL Agent Job

Updated March 16, 2016 08:02 AM