Versions Compared

Old Version 4

changes.mady.by.user IDERA

Saved on

compared with

New Version 5

changes.mady.by.user Unknown User (kgillan)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
select min(sample_id) from performancewmware_perf_sample where TO_CHAR(sample_time,'YYYY-MM-DD') - 'DATE';

...

Code Block
languagesql
delete from vmware_perf_aggregate where sample_id < ID; commit;
delete from vmware_perf_cluster where sample_id < ID; commit;
delete from vmware_perf_datastore_usage where sample_id < ID; commit;
delete from vmware_perf_datastore_vm_usage where sample_id < ID; commit;
delete from vmware_perf_disk_rate where sample_id < ID; commit;
delete from vmware_perf_entitlement where sample_id < ID; commit;
delete from vmware_perf_host_cpu where sample_id < ID; commit;
delete from vmware_perf_host_disk_io where sample_id < ID; commit;
delete from vmware_perf_host_disk_io_adv where sample_id < ID; commit;
delete from vmware_perf_host_network where sample_id < ID; commit;
delete from vmware_perf_host_power_state where sample_id < ID; commit;
delete from vmware_perf_mem where sample_id < ID; commit;
delete from vmware_perf_mem_advanced where sample_id < ID; commit;
delete from vmware_perf_network_rate where sample_id < ID; commit;
delete from vmware_perf_vm_cpu where sample_id < ID; commit;
delete from vmware_perf_vm_disk_io where sample_id < ID; commit;
delete from vmware_perf_vm_network where sample_id < ID; commit;
delete from vmware_perf_vm_power_state where sample_id < ID; commit;
delete from vmware_perf_vm_storage_usage where sample_id < ID; commit;
delete from vmware_perf_vm_vcpu where sample_id < ID; commit;
delete from vmware_perf_watts where sample_id < ID; commit;
 
  • The process above needs to be repeated for the Network performance tables.  Replace DATE below with the same target date as above in the format YYYY-MM-DD.
 
Code Block
languagesql
select min(id) from net_device_perf_sample where TO_CHAR(sample_time,'YYYY-MM-DD') - 'DATE';
   
  • Use the ID from the previous command in place of ID in the following commands. 
 
Code Block
languagesql
delete from net_device_perf_ping where sample_id < ID; commit;
delete from net_device_perf_port where sample_id < ID; commit;
 
 
  • The process above needs to be repeated for the retained performance tables.  Replace DATE below with the same target date as above in the format YYYY-MM-DD.
 
Code Block
languagesql
delete from erdc_decimal_data where TO_CHAR(sample_time,'YYYY-MM-DD') - 'DATE';
delete from erdc_int_data where TO_CHAR(sample_time,'YYYY-MM-DD') - 'DATE';
delete from erdc_string_data where TO_CHAR(sample_time,'YYYY-MM-DD') - 'DATE';
delete from ranged_object_value where TO_CHAR(sample_time,'YYYY-MM-DD') - 'DATE';