I have a customer who reported the following:
"I saw that there are index maintenance jobs running on the Compuware databases. Probably something builtin in the application since we are not running this.
We have ordinary jobs that do this so it´s overkill to have it run at this time also. We already do backups 19-22 so it´s not so good if its interfere with this work."
My question: is there a way to deactive the index maintenance jobs? Is this some task which can be done from their DBAs anyway?
CAS/ADS does it daily 9pm local time and on Sunday 3am.
You can change the time it starts or disable at all but then you should engage DBA in doing it on his own as report server DB w/o it will be slowing down.
By changing offsetTime as number of hours and minutes from midnight in below file:
you can change the time daily task runs.
thanks a lot for the quick response.
I will check with the DBA. To disable it, I can simply comment the respective section for DefragIndexesOnChangedTables and WeeklyDBMaintenance in the mentioned xml right?