• Forums
    • Public Forums
      • Community Connect
      • Dynatrace SaaS & Managed
        • Dynatrace SaaS & Managed Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Free Trial
        • AppMon & UEM Open Q&A
        • AppMon & UEM Plugins
      • Data Center RUM
        • DC RUM Open Q&A
        • Enterprise Synthetic Monitoring
      • Dynatrace Synthetic Monitoring
        • Dynatrace Synthetic Open Q&A
        • Dynatrace Synthetic EAP Feedback
      • Keynote Synthetic Monitoring
        • Keynote Synthetic Open Q&A
        • Keynote Synthetic EAP Feedback
      • BSM Open Q&A
      • Server Monitoring Open Q&A
      • Dynatrace Open Q&A en Español
  • Home /
  • Public Forums /
  • Data Center RUM /
  • DC RUM 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 |2000 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

1 Reply

· Add your 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 |2000 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
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)

Your answer

Hint: You can notify a user about this post by typing @username

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

Welcome the
Dynatrace Community Forums

Check out the Forum User Guide and Forum Guidelines to learn how to get started.

Community Member of the Month
August 2017

Announcing Dynatrace's Community Member of the Month for August 2017, Rick B.! Click here to read more!

Follow this Question

Answers Answers and Comments

2 People are following this question.

avatar image avatar image

Forum Tags

known issue universal decode rum console mobileapp data delay oracle data retention metrics dmi all other operations sites url learning smtp monitoring sequence transactions virtualization dc rum sso splunk task scheduling citrix http operation amd reporting trace good to know sniffing point diagnostics url aging installation currency licensing sending reports gomez 12.4 xml ssl decryption community corba failover http express tcam snc voip community awards span ports dna reports buc data export high speed amd transaction tds user aggregation best practices hardware ads configuration security high five award rest api operational attributes netflow css web soap appflow data processing 17.0 sap esm amd restarts cba redhat autodiscovery rcon dcrum data validation integration bmc web performance monitoring rtmgate sql smb migration 12.3 mq snmp oracle applications rtmjob capacity jolt iiop user recognition url monitoring regex ahs cas exchange performance byte 12.4.10 tips and tricks dashboard cluster bulk insert hierarchy cas benchmark tool baselines data access 12.2 parameters traps mssql oracle forms scalability software services rhel7 documentation alerting dc rum extensions administration
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace SaaS & Managed
      • Dynatrace SaaS & Managed Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Free Trial
      • AppMon & UEM Open Q&A
      • AppMon & UEM Plugins
    • Data Center RUM
      • DC RUM Open Q&A
      • Enterprise Synthetic Monitoring
    • Dynatrace Synthetic Monitoring
      • Dynatrace Synthetic Open Q&A
      • Dynatrace Synthetic EAP Feedback
    • Keynote Synthetic Monitoring
      • Keynote Synthetic Open Q&A
      • Keynote Synthetic EAP Feedback
    • BSM Open Q&A
    • Server Monitoring Open Q&A
    • Dynatrace Open Q&A en Español