Index maintenance jobs for DCRUM databases

Question

Question by Dennis M. · Mar 25, 2015 at 02:20 PM ·

Index maintenance jobs for DCRUM databases

Hi,

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?

Best regards,
Dennis

0

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Answer 1 · 2015-03-25T14:51:38Z

Answer by Adam P. · Mar 25, 2015 at 02:51 PM

Dennis,

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:

C:\Program Files\Compuware\CAS\config\tasks-100-hcbs.xml

Â     
        
            adlex.delta.server.repository.scheduledTasks.DefragIndexesOnChangedTables

            5

you can change the time daily task runs.

0 Show 5 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Dennis M. · Mar 25, 2015 at 03:12 PM 0

Share

Hi Adam,

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?

Best regards,
Dennis

Adam P. ♦♦ Dennis M. · Mar 25, 2015 at 03:31 PM 0

Share

Yes, but please first consider changing the start time ...

Anyway if you decide to turn it off someone needs to defragment indexes manually ...

Dennis M. Adam P. ♦♦ · Mar 25, 2015 at 03:35 PM 0

Share

Yes, I will make sure and am in contact with the DBA. Just wanted to know how it would work and if commenting is enough.

Thanks, Adam.

Adam P. ♦♦ Dennis M. · Mar 25, 2015 at 04:18 PM 0

Share

Yes, just make sure you comment all line from <task> to </task> (smile)

Dennis M. Adam P. ♦♦ · Mar 25, 2015 at 04:20 PM 0

Share

of course (wink)

Index maintenance jobs for DCRUM databases

1 Reply

How to get started

NAM 2019 SP5 is available

LIVE WEBINAR

Follow this Question

Forum Tags