Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the maintenance windows used for? Can I remove it if I don want to run automatic statistics collection job GATHER_STATS_JOB?

April 26, 2017automatic collection gather_stats_job Job maintenance remove run statistics Used Windows

0

Posted

What is the maintenance windows used for? Can I remove it if I don want to run automatic statistics collection job GATHER_STATS_JOB?

1 Answer

0

Posted

The maintenance window is some predefined time window for system maintenance tasks. By default, not only GATHER_STATS_JOB is scheduled to run in these windows, certain internal maintenance tasks also run in them. If the maintenance windows are removed by the DBA, GATHER_STATS_JOB will not run and the internal maintenance tasks will run whenever the system deems necessary. So it is better to keep the maintenance windows around and adjust them to a time where your system is not under heavy load.