Showing results for 
Show  only  | Search instead for 
Did you mean: 

This product reached the end of support date on March 31, 2021.

Code for the PWH CleanUp task

DynaMight Advisor
DynaMight Advisor

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!


DynaMight Leader
DynaMight Leader

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.



Hi Babar,

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


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.



Dynatrace Pro
Dynatrace Pro

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,