• Forums
    • Public Forums
      • Community Connect
      • Dynatrace
        • Dynatrace Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Open Q&A
      • Network Application Monitoring
        • NAM Open Q&A
        • Enterprise Synthetic Monitoring
      • Synthetic Classic
        • Synthetic Classic Open Q&A
  • Home /
  • Public Forums /
  • Network Application Monitoring /
  • NAM Open Q&A /
avatar image
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

Comment

People who like this

0 Show 0
10 |2000000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 52.4 MB each and 262.1 MB total.

1 Reply

  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image

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.

Comment

People who like this

0 Show 5 · Share
10 |2000000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 52.4 MB each and 262.1 MB total.

avatar image 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

avatar image 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 ...

avatar image 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.

avatar image 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)

 

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

of course (wink)

Welcome to the
Dynatrace Community Forums

Check out the Community User Guide and First steps in the forum to learn how to get started.

Community Member of the Month
July 2019

Announcing Dynatrace's Community Member of the Month for July 2019, Wai C.! Click here to read more!

Employee Member of the Month
July 2019

Announcing Dynatrace's Employee Member of the Month for July 2019, Patrick H.! Click here to read more!

Live webinar: Automate Deployment and Site Reliability with Bots, ChatOps, and Dynatrace

oin us in a session where Zohaib UL-Hassan and Nestor Zapata from Citrix will explain their different bot use cases, get insights into how they implemented them, and learn how you can integrate Dynatrace monitoring data into your own bot automation framework.
Tuesday, July 23, 4:00 p.m. CEST/10:00 a.m. EDT
Register here

Live webinar: Automate Deployment and Site Reliability with Bots, ChatOps, and Dynatrace

oin us in a session where Zohaib UL-Hassan and Nestor Zapata from Citrix will explain their different bot use cases, get insights into how they implemented them, and learn how you can integrate Dynatrace monitoring data into your own bot automation framework.
Tuesday, July 23, 4:00 p.m. CEST/10:00 a.m. EDT
Register here

NAM 2019 SP1 is available

See what's been improved in metric charts, Report explorer, and Reporting data servers screen.
Learn more

Live webinar: Automate Deployment and Site Reliability with Bots, ChatOps, and Dynatrace

oin us in a session where Zohaib UL-Hassan and Nestor Zapata from Citrix will explain their different bot use cases, get insights into how they implemented them, and learn how you can integrate Dynatrace monitoring data into your own bot automation framework.
Tuesday, July 23, 4:00 p.m. CEST/10:00 a.m. EDT
Register here

Follow this Question

Answers Answers and Comments

2 People are following this question.

avatar image avatar image

Forum Tags

esm security siebel license nam probe wan citrix dna rest api configuration mq alerting NAM 2018 dashboard dcrumadvisory reports css nam universal decode mobileapp rum ads sap nam console scripting nam server sequence transactions upgrade
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace
      • Dynatrace Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Open Q&A
    • Network Application Monitoring
      • NAM Open Q&A
      • Enterprise Synthetic Monitoring
    • Synthetic Classic
      • Synthetic Classic Open Q&A