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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics