sys.dm_os_wait_stats', CLEAR
What is the impact of running 'sys.dm_os_wait_stats', CLEAR on production server?
February 24th, 2015 7:01pm
It clears the wait stats so you will lose this important information. However, these stats are also reset automatically when SQL is restarted. Other that losing the important information, you will NOT encounter any performance nor any other penalties for
clearing the stats.
Free Windows Admin Tool Kit Click here and download it now
February 24th, 2015 7:22pm
Please don't run it unless you are doing some testing and have very specific reason to do it.
February 25th, 2015 12:15am