These commands are permanent. All deleted data will be lost. Ensure that you complete a full data backup before proceeding with these commands.
The following commands will delete all performance data prior to a specified date:
Get the earliest sample ID for the specified day. All data samples collected prior to this day will be deleted. Replace DATE below with your target date in the format YYYY-MM-DD:
select min(id) from performance_sample where CONVERT(CHAR(10),sample_time,120) = 'DATE';
- Use the ID from the previous command in place of ID in the following commands. It is strongly recommended that deletions be completed in small chunks (e.g. 2 weeks or 1 month at a time) rather than attempting one large delete statement.
delete from performance_aggregate where sample_id <ID; go; delete from performance_cpu where sample_id <ID; go; delete from performance_disk where sample_id <ID; go; delete from performance_esx3_workload where sample_id <ID; go; delete from performance_fscap where sample_id <ID; go; delete from performance_network where sample_id <ID; go; delete from performance_nrm where sample_id <ID; go; delete from performance_psinfo where sample_id <ID; go; delete from performance_vmware_workload where sample_id <ID; go; delete from performance_vxvol where sample_id <ID; go; delete from performance_who where sample_id <ID; go;