question

Josep C. avatar image
Josep C. asked ·

Code for the PWH CleanUp task

Hi all,

my customer is interested in the details for the Performance Warehouse CleanUp task, where can I see the code for this cleanup task? In my case the PWH is one SQL Server.

Thanks in advance!

databaseadministration7.2performance warehouse
10 |2000000 characters needed characters left characters exceeded

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

Peter K. avatar image
Peter K. answered ·

Hi Josep,

the clean-up task does the following (in that order):

- remove unreferenced CI data

- remove deleted system profile data

- remove deleted measure configs

- remove unreferenced or deleted incident rules

- remove unreferenced percentiles and age / aggregate the rest

- remove unreferenced / timed-out measurements and age / aggregate the rest

- remove dangling / timed-out incident records

- remove unreferenced agent records

- remove unreferenced thersholds

Each of these steps is a set of more or less complex SQL statements. We don't disclose them as they're prone to change even in minor updates.

The logging information in Repository.0.0.log gives a relatively detailed summary of the single steps.

Best regards,

Peter

Share
10 |2000000 characters needed characters left characters exceeded

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

Babar Q. avatar image
Babar Q. answered ·

Hello @Josep Maria Camps R.

I guess you are looking for the below information. If you think you need to tweak AutoPurge further, or this is not the exact code you are looking for then contact support.

https://www.dynatrace.com/support/doc/appmon/administration/server-administration/performance-warehouse/performance-warehouse-partioning/?oracle%3C-%3Emicrosoft-sql-server%3C-%3Edb2%3C-%3Epostgresql=microsoft-sql-server

Regards,

Babar

2 comments Share
10 |2000000 characters needed characters left characters exceeded

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

Hi Babar,

I'm interested in the code for the CleanUp task not for the PWH partitioning.

Regards,

0 Likes 0 · ·

Hello @Josep Maria Camps R.

Yes. I understand and that was just a reference.

I guess DBA or Dynatrace Support can provide the exact code.

Regards,

Babar

0 Likes 0 · ·